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

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