วันพฤหัสบดีที่ 9 กุมภาพันธ์ พ.ศ. 2555

[ db2 ] SQL1220N The database manager shared memory set cannot be allocated. SQL1032N No start database manager command was issued. SQLSTATE=57019

In cmd
H:\>db2start
DB2_01-0 : The service has returned a service-specific error code.

09/02/2555 13:23:40     0   0   SQL1220N  The database manager shared memory set
cannot be allocated.
SQL1032N  No start database manager command was issued.  SQLSTATE=57019
or full error in Control Center
The database manager shared memory set cannot be allocated.

Explanation: 

The database manager could not allocate its shared memory set. The cause
of this error may be insufficient memory resources either for the
database manager or the environment in which its operation is being
attempted. Memory resources that can cause this error include: 
*  The number of shared memory identifiers allocated in the system
*  The size of the shared memory segment
*  The amount of paging or swapping space available in the system
*  The amount of physical memory available in the system

User response: 

One or more of the following: 
*  Validate that sufficient memory resources are available to satisfy
   the database manager's requirements, and those of the other programs
   running on the system.
*  On Linux 32-bit, increase the kernel parameter shmmax to 256 MB. On
   Linux 64-bit, increase the kernel parameter shmmax to 1GB.
*  Reduce database manager's memory requirement for this memory set by
   reducing the database manager configuration parameters which affect
   it. These are: fenced_pool and, numdb.
*  Where appropriate, stop other programs using the system.


In db2 command window,
C:\Program Files\IBM\SQLLIB_01\BIN>db2 update dbm cfg using INSTANCE_MEMORY AUTO
MATIC
DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.


In cmd
H:\>db2start
09/02/2555 13:24:14     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.


ref : ibm

ไม่มีความคิดเห็น:

LinkWithin

Related Posts Plugin for WordPress, Blogger...