Automatic Implementation of CLP updates

Several Methods for automatic implementation of CLP updates to stop db2 from automatically submitting settings from clp: 1. Go to command line settings: C: \ Users \ Administrator> db2 (c) copyright IBM Corporation 1993,200 7DB2 client 10.1.0's command line processor www.2cto.com can issue Database Manager commands and SQL statements from a command prompt. For example: db2 => connect to sampledb2 => bind sample. bnd for general help, enter :?. For Command help, enter :? Command, where command can be the first few keywords of the Database Manager command. Example :? How does catalog database Help with the catalog database Command? CATALOG is used to help all CATALOG commands. To exit the db2 interaction mode, enter QUIT at the command prompt. In non-interactive mode, all commands must be prefixed with "db2. To LIST the settings of the current command options, enter list command options. For more help, see Online Reference Manual. Db2 => list command options command line processor option set the backend process wait time (seconds) (DB2BQTIME) = 1 Number of retries connected to the backend (DB2BQTRY) = 60 Request queue waiting time (seconds) (DB2RQTIME) = 5 input queue waiting time (seconds) (DB2IQTIME) = 5 Command Option (DB2OPTIONS) =-c www.2cto.com option description current settings ------ -------------------------------------------------- a display sqlca off-c automatically implement ON-d retrieval and display XML declaration OFF-e display SQLCODE/sqlstate off-f Read input file OFF-I: Show XML data with indentation. OFF-l: record the command to the history file. OFF-m: show the number of affected rows. OFF-n: remove the change. Line Character OFF-o display output ON-p display interactive input prompt ON-q reserved space and line feed OFF-r save output to report file OFF-s stop execution when command Error -t set statement termination character OFF-v Return Current command OFF-w display FETCH/SELECT warning message ON-x do not print column title OFF-z save all output to output file OFF db2 => the update command options using c offDB20000I update command options command is successfully completed. Db2 => list command options command line processor option set the backend process wait time (seconds) (DB2BQTIME) = 1 Number of retries connected to the backend (DB2BQTRY) = 60 Request queue waiting time (seconds) (DB2RQTIME) = 5 input queue waiting time (seconds) (DB2IQTIME) = 5 Command Option (DB2OPTIONS) =-c www.2cto.com option description current settings ------ -------------------------------------------------- a display sqlca off-c automatically implement OFF-d retrieval and display XML declaration OFF-e display SQLCODE/sqlstate off-f Read input file OFF-I: Show XML data with indentation. OFF-l: record the command to the history file. OFF-m: show the number of affected rows. OFF-n: remove the change. Line Character OFF-o display output ON-p display interactive input prompt ON-q reserved space and line feed OFF-r save output to report file OFF-s stop execution when command Error -t set statement termination character OFF-v Return Current command OFF-w display FETCH/SELECT warning message ON-x do not print column title OFF-z save all output to output file OFF db2 => the quitDB20000I QUIT command is successfully completed. The command line processor for www.2cto.com C: \ Users \ Administrator> db2 (c) Copyright IBM Corporation 1993,200 7DB2 client 10.1.0 can issue Database Manager commands and SQL statements from a command prompt. For example: db2 => connect to sampledb2 => bind sample. bnd for general help, enter :?. For Command help, enter :? Command, where command can be the first few keywords of the Database Manager command. Example :? How does catalog database Help with the catalog database Command? CATALOG is used to help all CATALOG commands. To exit the db2 interaction mode, enter QUIT at the command prompt. In non-interactive mode, all commands must be prefixed with "db2. To LIST the settings of the current command options, enter list command options. For more help, see Online Reference Manual. Db2 => list command options command line processor option settings www.2cto.com backend process wait time (seconds) (DB2BQTIME) = 1 Number of retries connected to the backend (DB2BQTRY) = 60 Request queue waiting time (seconds) (DB2RQTIME) = 5 input queue waiting time (seconds) (DB2IQTIME) = 5 Command Option (DB2OPTIONS) =-c option description current settings ------ -------------------------------------------------- a display sqlca off-c automatically implement ON-d retrieval and display XML declaration OFF-e display SQLCODE/sqlstate off-f Read input file OFF -I: Show XML data with indentation. OFF-l: record the command to the history file. OFF-m: show the affected number of rows. OFF-n: remove the change. Line Character OFF-o display output ON-p display interactive input prompt ON-q reserved space and line feed OFF-r save output to report file OFF-s stop execution when command Error -t set statement termination character OFF-v Return Current command OFF-w display FETCH/SELECT warning message ON-x do not print column title OFF-z save all output to output file OFF again open a session, -c option update is invisible. 2. Operating System command Line setting 1: C: \ Users \ Administrator> db2 list command options | find/I "-c"-c automatically implements ON www.2cto.com C: \ Users \ Administrator> db2 update command options using c offDB20000I update command options command is successfully completed. C: \ Users \ Administrator> db2 list command options | find/I "-c"-c automatically implements ON under the operating system command line. After the update, check that it has not changed. 3. Operating System-level command line Setting 2: C: \ Users \ Administrator> db2 + c (c) the command line processor of the Copyright IBM Corporation 1993,200 7DB2 client 10.1.0 can issue Database Manager commands and SQL statements from a command prompt. For example, db2 => connect to sampledb2 => bind sample. bnd www.2cto.com. For general help, enter :?. For Command help, enter :? Command, where command can be the first few keywords of the Database Manager command. Example :? How does catalog database Help with the catalog database Command? CATALOG is used to help all CATALOG commands. To exit the db2 interaction mode, enter QUIT at the command prompt. In non-interactive mode, all commands must be prefixed with "db2. To LIST the settings of the current command options, enter list command options. For more help, see Online Reference Manual. Db2 => list command options command line processor option set the backend process wait time (seconds) (DB2BQTIME) = 1 Number of retries connected to the backend (DB2BQTRY) = 60 Request queue waiting time (seconds) (DB2RQTIME) = 5 input queue waiting time (seconds) (DB2IQTIME) = 5 Command Option (DB2OPTIONS) =-c option description current settings ------ -------------------------------------------------- a display sqlca off www.2cto.com-c automatically implement OFF-d retrieval and display XML declaration OFF-e display SQLCODE/sqlstate off-f Read input file OFF-I display XML data with indentation OFF-l record the command to the history file OFF-m show affected rows OFF-n Division Remove wrap character OFF-o display output ON-p display interactive input prompt ON-q retain space and line feed OFF-r save output to report file OFF-s stop execution when command error occurs OFF-t setting statement termination character OFF-v Return Current command OFF-w display FETCH/SELECT warning message ON-x do not print column title OFF-z save all output to output file OFF db2 => the quitDB20000I QUIT command is successfully completed. C: \ Users \ Administrator> db2 list command options | find/I "-c"-c automatically implements ON www.2cto.com. As shown in the preceding figure, updates are visible at the same session level; however, updates are invisible in different sessions. 4. Global settings: C: \ Users \ Administrator> db2 list command options | find/I "-c"-c automatically implements ON C: \ Users \ Administrator> db2set db2options = + c C: \ Users \ Administrator> db2 list command options | find/I "-c"-c automatically implements OFF global settings, restart the database.