m 6.1+)

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 vii

Managing the dba/m Database Manager Profile.................................... 4-2

Change dba/m Database Manager Profile ..........................................................4-2

Add Nodes........................................................................................................4-3

Delete Nodes ....................................................................................................4-3

Managing User Profiles........................................................................ 4-3

Add Users.........................................................................................................4-3

Change Users....................................................................................................4-5

Delete Users .....................................................................................................4-5

Volume ................................................................................................ 4-6

Display Attributes.............................................................................................4-7

Display Order ...................................................................................................4-7

Notifier................................................................................................. 4-7

Email information. ............................................................................................4-8

Pager Information.............................................................................................4-8

Notification Interval..........................................................................................4-8

Add, Edit, Remove User...................................................................................4-9

SQL Inventory...................................................................................... 4-9

Default Logon ...................................................................................... 4-9

Map Defines....................................................................................... 4-10

Add Map Defines............................................................................................4-11

Change Map Defines.......................................................................................4-12

Delete Defines ................................................................................................4-12

CHAPTER 5. USING dba/m Database Manager COMMANDS......... 5-1

Saving Commands................................................................................ 5-1

Displaying Commands.......................................................................... 5-2

Executing Commands........................................................................... 5-3

Queuing Commands ............................................................................. 5-4

Retrieving Commands .......................................................................... 5-5

CHAPTER 6. MONITORING DISK-SPACE USAGE........................ 6-1

Displaying Volume Usage.................................................................... 6-1

Customizing the Volume Display ......................................................... 6-2

Monitoring Objects .............................................................................. 6-2

Choosing Objects..............................................................................................6-3

Managing the Objects .......................................................................................6-6

Displaying Alarms................................................................................ 6-9

CHAPTER 7. ANALYZING AND TUNING QUERY

PERFORMANCE........................................................... 7-1

Analyzing Queries in Programs ............................................................ 7-1

Choose a Program ............................................................................................7-2