Console and Console-Like Commands

The two basic changes involving console commands as follows:

For most of the console and console-like commands, the same command can be issued from all of the following:
- The true console, using MODIFY in z/OS and MSG in z/VSE
- SQL, using the SQL_CONSOLE (SQX) Dynamic System Table
- MUF startup options, with some exceptions
- DBUTLTY, using the function COMM OPTION=CONSOLE,OPTION2=
The SQL_CONSOLE (SQX) Dynamic System Table has been created. This table provides a new method of issuing maintenance commands. You can now do inserts with a character string that is formatted by all the console commands. This method replaces SQL maintenance to all other tables where it previously existed.

The following new console commands are in addition to the MUF startup options that have console-like commands.

SQL_CODE_ERROR: SQL_CODE_ERROR modifies what is dumped to the PXXSQL file when the specified SQLCODE occurs. On certain occasions, CA Support may request that you use SQL_CODE_ERROR. SQL_CODE_ERROR modifies what is dumped to the PXXSQL file when the specified SQLCODE occurs.
SQL_LRU_STATEMENT_CACHE: SQL_LRU_STATEMENT_CACHE speeds processing by defining a cache to hold SQL statements in memory for reuse.
SQL_OPTIMIZATION_LEVEL: SQL_OPTIMIZATION_LEVEL specifies the level of SQL optimization that the SQL table join optimizer uses. It replaces DIAGOPTION 9,1,ON, which is no longer supported. We recommend a level of 0, the default, as the best level to give the broadest benefits during table join optimization.
SQL_SQUARE_BRACKETS: SQL_SQUARE_BRACKETS can be used to direct SQL to recognize alternative code point values for square bracket characters.
SQL_STATE_ERROR: SQL_STATE_ERROR modifies what is dumped to the PXXSQL file when the specified SQLSTATE occurs.

Note: For more information, see the Maintenance using Console Commands topic in the CA Datacom/DB Database and System Administration Guide.