Objectives
Audience and Prerequisite

8:30 Module 1: Architecture

• dba/m® is a client-server application.
• The client is a Microsoft Windows based GUI running on PCs with Windows 95/98/NT/2K/XP.
• The server components run on HP Nonstop Himalaya Servers under the pathway environment.
• Some context sensitive servers run outside Pathway.
  

9:00 Module 2 : dba/m® installation

• Both client and server components are shipped in the same CD.
• dba/m® installation requires:
  • Client side install of client components.
  • ftp of server components to Compaq Nonstop Himalaya servers.
  • Installing the server components.
    
    

9:15 Module 3 : Starting a dba/m® session

• Invoking dba/m® client brings up a logon window.
• User ID and Password should represent valid Guardian user accounts.
• Refresh retrieves SQL-object information from the Tandem node.
• No Refresh uses information cached during previous session.
• Logon Requirements: NSK Logon Id

9:30 Module 4 : Object Tree

• Object Tree
• Custom Object Tree

10:00 Break
10:15 Module 5: dba/m® Options

• dba/m® users
• dba/m® Profile
• dba/m® user profile
• Adding nodes to dba/m®

10:45 Module 6: Performing Database Management Tasks

• Monitoring Disk Space
• An Triggered Alarm
• Analyzing Historical Data
• Query Analysis and Tuning
• Program Query Analysis Window
• Managing Defines
• Adhoc Query
• Accessing Table Statistics
• Batch Job Management
  

11:15 Module 7: Managing SQL Objects

• Catalogs
• Tables
• Table Partitions
• Indexes
• Index Partitions
• Views
• SQL Programs

12:00 Lunch

1:00 Module 7: Managing SQL Objects(cont.)

• Catalogs
• Tables
• Table Partitions
• Indexes
• Index Partitions
• Views
• SQL Programs

1:30 Module 8: Working with dba/m® commands

• SaveCommand, ShowCmd, ExecuteCmd, QueueCmd, RetrieveCmd
• Auditing dba/m® commands
• Error Information Utility
  

2:00 Break
2:15 Lab/Hands On
4:00 Recap/Q & A
5:00 Conclusion