HP Integrity NonStop J-Series - Manual (Page 5)

Viewing the table index columns.....................................................................................59
Viewing the table index attributes....................................................................................59
Viewing the DDL output for a table index..........................................................................60
Viewing information related to table index partitions..........................................................60
Displaying table triggers and their properties.........................................................................61
Viewing the table trigger attributes..................................................................................62
Viewing information on related objects.............................................................................62
Viewing the DDL output for a table trigger........................................................................63
Managing objects using the SHOW DDL option.........................................................................63
Viewing schema views and their properties................................................................................64
Viewing properties related to view columns...........................................................................65
Viewing attributes of a view................................................................................................66
Viewing information on related objects.................................................................................66
Viewing DDL information of a table......................................................................................66
Viewing information related to view privileges........................................................................67
Viewing procedures and their properties....................................................................................67
Viewing attributes of a procedure.........................................................................................68
Viewing parameters of a procedure......................................................................................69
Viewing information on related objects.................................................................................70
Viewing DDL information of a procedure...............................................................................70
Viewing information related to procedure privileges................................................................70
Viewing SQL/MP aliases and their properties.............................................................................71
Viewing attributes of the SQL/MP alias.................................................................................72
Viewing DDL information of a SQL/MP alias.........................................................................72
Viewing table statistics and their properties................................................................................72
7 Managing MXCS objects..........................................................................76
Viewing MXCS servers............................................................................................................76
Stopping an MXCS server........................................................................................................78
Viewing MXCS Services...........................................................................................................78
Starting up an MXCS service....................................................................................................79
Stopping an MXCS service......................................................................................................80
Viewing data sources..............................................................................................................81
Creating a data source...........................................................................................................82
Using General Properties....................................................................................................83
Adding and modifying the resource management policy.........................................................85
Using the DEFINEs and SETs tab..........................................................................................85
Using the Control Query Defaults tab...................................................................................87
Using the Control Table Statements tab.................................................................................87
If-Locked.......................................................................................................................88
MDAM........................................................................................................................88
Priority.........................................................................................................................88
Similarity check............................................................................................................89
Table Lock....................................................................................................................89
Timeout........................................................................................................................89
Copying a data source............................................................................................................89
Starting up a data source........................................................................................................90
Stopping a data source...........................................................................................................90
Updating a data source..........................................................................................................91
Deleting a data source............................................................................................................91
Starting and stopping server traces...........................................................................................91
Viewing MXCS user permissions...............................................................................................92
Adding an MXCS user............................................................................................................93
Editing MXCS user permissions.................................................................................................94
Deleting an MXCS user...........................................................................................................94
Contents 5