db2dumpSQLCodesInterval keyword
Specifies the time period in seconds during which the log information for the SQLCODE is not captured.
- Equivalent CLI keyword
- db2dumpSQLCodesInterval
- Equivalent IBM® data server provider for .NET connection string keyword
- db2dumpSQLCodesInterval
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="db2dumpSQLCodesInterval" value="20"/>- Default setting
-
- The default value of the db2dumpSQLCodesInterval keyword is 0.
- Usage Notes
-
db2dumpSQLCodesInterval can be set to positive integer values in seconds. Fractional times will be ignored. It will specify the number of seconds to wait after the occurrence of the first SQLCODE to begin logging information again. The SQLCODE will be the value set in the db2dumpSQLCodes keyword. The value set in db2dumpSQLCodesInterval is applicable only if there is a valid value in the db2dumpdataSQLCodes keyword.
If a negative value is specified, the default value 0 will be used & this will result in the earlier behavior of logging the duplicate information.
In the db2dsdriver.cfg configuration file, the db2dumpSQLCodesInterval keyword must be placed under the global parameters section.
If the SQLCODE SQL30108N is specified in the db2dumpSQLCodes keyword , log information will be captured on the first occurrence of SQL30108N in any of the threads. The value specified in the db2dumpSQLCodesInterval keyword will then be added to the current time X. For example, if db2dumpSQLCodesInterval = 20,then the log information for all other SQL30108N occurrences will not be captured until the current time Y exceeds the time X + 20 seconds. However, any other configured SQL code will still be captured during this interval period.
The server and client product details will be provided in the following format:
[ Product : QDB2/LINUXX8664 Db2 v10.5.0.6 ]
[ Level Identifier : 0607010E ]
[ Db2 Code Release : SQL10056 ]
[ Bits : 64 ]
[ Informational Tokens : "Db2 v10.5.0.6","n150125","IP23643","Fixpack 6" ]
[ DBMS NAME : Db2 ]
[ Server Type : z/OS ]
[ Version : 09.01.0005 ]
The details of the SQLCA structure will be formatted and dumped into the log file.
To provide diagnostic information, the following will be logged for SQL30108N and SQL20542N SQLCODES:
TransportReuse=0, InUnitOfWork=1, dari_state=0, ReadOnlyTxn=1, InterruptSeamless=1, FailoverRetryState=1, XAFirstSQL=0, FirstSQL=0, XAStaticReg=0,SeamlessRetryCount=2
The SRVDGN contents belonging to an AGNPRMRM for -1224 will not be dumped into the serviceability log. This information is already dumped into the db2diag.log. The timestamp along with the process-id and thread-id can be used to map the required information in the db2diag.log and serviceability log.
RECEIVETIMEOUT is not supported in .NET driver. Therefore the scenario in which 20542 is returned instead of 30108 when RECEIVETIMEOUT is less than the query timeout and lock timeout is not applicable to Db2® .NET provider.