Correct analysis of ZRC errors in the DB2diag. log Database

This article focuses on DB2diag. how should I analyze the ZRC errors in the log database? I saw DB2diag on the relevant website two days ago. the information on how to analyze ZRC errors in the log database is quite good, so I will share it with you.

Log, ZRC

This post was last edited by Alan

For some zrc code, there are two main methods for analysis (but some code cannot be converted ):

1. For example, in the DB2diag. log File, ZRC = 0xFFFFFBF0 is displayed.

Get 40F with FFFFFFFF-FFFFFBF0 first, then 40F + 1 get 410

Then convert 410 to 1040 in decimal format.

So we get the DB2 error code: SQL1040N

We can check the error details based on this error number:

 
 

  
  
DB2 ? sql1040n 
 
 

SQL1040N has reached the maximum number of applications connected to the database.

Explanation:

The number of applications connected to the database is equal to the maximum value defined in the database configuration file.

Cannot process this command.

User response:

Wait until other applications are disconnected from the database. If more applications are required to run concurrently

The value of maxappls. When all applications are disconnected from the database and the data is restarted

The new value takes effect.

 
 

  
  
sqlcode : -1040 
 
 

2. Use the new tool DB2diag provided by DB2V8.2, for example:

 
 

  
  
DB2diag -rc 0xFFFFFBF0  
 
 

The above content is an introduction to how to analyze the ZRC errors in DB2diag. log. I hope you will find some gains.

The above content is an introduction to how to analyze the ZRC errors in DB2diag. log (my experiences). I hope you will gain some benefits.