What do you see in suspending DB2 diag. log?

The following article describes the suspension of DB2 diag during the parallel LOAD Operation of DB2. log shows the DIA8533C error. If you encounter a similar situation in the actual operation, but you do not know how to solve it correctly, so the following articles must be good teachers and friends for you.

Product: DB2 UDB ESE

Platform: HPUX 11

Version: V8

Problem description:

On the HPUX operating system, a physical machine has multiple logical partitions. When performing parallel LOAD operations, the LOAD operation is suspended and the error DIA8533C is displayed in DB2diag. log.

Answer:

The following error is displayed in DB2 diag. log:

 
 

  
  
2006-06-02-18.00.56.823018+480 I25267A383 LEVEL: Severe  
  
  
PID : 28027 TID : 1 PROC : DB2lload 3  
  
  
INSTANCE: XXXX NODE : 003 DB : XXXX  
  
  
APPHDL : 0-762 APPID: O5402789.C2D8.04B862100054  
  
  
FUNCTION: DB2 UDB, database utilities, sqluAllocTBufs, probe:100  
  
  
MESSAGE : DIA8533C The system memory limit was reached. 
 
 

This error occurs because the Kernel Parameter of the operating system is too small, which causes DB2 to fail to operate normally during Message Queue operations. You only need to re-adjust the kernel parameters of HPUX and then restart DB2.

To install a DB2 partitioned database on the HPUX operating system, you must first adjust the kernel parameters of HPUX to ensure that sufficient system resources are available. For specific kernel parameter adjustment requirements, see DB2 Information Center:

Http://publib.boulder.ibm.com/infocenter/DB2luw/v8//topic/com.ibm.DB2.udb.doc/start/t0006477.htm

In addition, DB2 provides a command DB2osconf to help adjust HPUX kernel parameters. For details, see DB2 Information Center:

Http://publib.boulder.ibm.com/infocenter/DB2luw/v8/index.jsp? Topic =/com.ibm.DB2.udb.doc/core/r0008113.htm

Command help:

 
 

  
  
DB2osconf -h  
  
  
Usage:  
  
  
-c # Client only  
  
  
-f # Compare to current  
  
  
-h # Help screen  
  
  
-l # List current  
  
  
-m <mem in GB> # Specify memory in GB  
  
  
-n <num CPUs> # Specify number of CPUs  
  
  
-p <perf level> # Msg Q performance level (0-3)  
  
  
-s <scale factor> # Scale factor (1- 2 )  
  
  
-t <threads> # Number of threads  
 
 

Note: In a partitioned database environment, if you have multiple logical partitions on a physical machine, you should add the value recommended by DB2osconf. You can also use the-p and-s parameters to specify an extended index. If there are three logical partitions on a physical machine, we can use the following command to obtain the appropriate configuration parameters:

 
 

  
  
DB2osconf -p 3 -s 2  
 
 

The above content is the introduction of the DIA8533C error in the DB2 diag. log suspended during the parallel LOAD operation on DB2. I hope you can gain some benefits.