DB2 dSource Link Failure: SQL0930N There is Not Enough Storage Available to Process the Statement (KBA1739)
Applicable Delphix Versions
Major Release |
All Sub Releases |
5.2 | 5.2.2.0, 5.2.2.1, 5.2.3.0 |
5.1 |
5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0 |
Issue
During DB2 dSource linking, ingestion fails with this error found in the DB2 toolkit log, under DB2_Toolkit_Directory/DB2/logs/<DB2_Instance_Name>/<dSource_Name>.diag.log
Sample message:
restore db DB2_DSRC from /backups/delphix taken at 20180626144806 on /var/opt/delphix/toolkit/DB2/mnts/db2_instance/DB2_DSRC into RENAME2 logtarget /var/opt/delphix/toolkit/DB2/mnts/db2_instance/DB2_DSRC/db2_instance/DB2_DSRC/logs newlogpath /var/opt/delphix/toolkit/DB2/mnts/db2_instance/DB2_DSRC/db2_instance/DB2_DSRC/logs replace existing redirect generate script /var/opt/delphix/toolkit/DB2/logs/db2_instance/DB2_DSRC.rstr without prompting SQL0930N There is not enough storage available to process the statement. SQLSTATE=57011
Background
This is a Linux RHEL environment.
Delphix version 5.2.5.0 (DB2 Database level)
DB2 version 10.5
Troubleshooting
On the Linux machine run the ipcs -l command. Sample output:
[delphix@db2_environment ~]$ ipcs -l ------ Messages Limits -------- max queues system wide = 19674 max size of message (bytes) = 65536 default max size of queue (bytes) = 65536 ------ Shared Memory Limits -------- max number of segments = 4096 max seg size (kbytes) = 10074960 max total shared memory (kbytes) = 20149920 min seg size (bytes) = 1 ------ Semaphore Limits -------- max number of arrays = 2560 max semaphores per array = 250 max semaphores system wide = 256000 max ops per semop call = 100 semaphore max value = 32767
Resolution
Make proper adjustments to the shared memory.
Additional Information
Here are some helpful links regarding DB2 memory issues:
DB2 warning message ADM6073W received during slow performance on Linux server
External Links
Making changes (made in config file and these are applied at the kernel level):
Other information on ipcs:
http://man7.org/linux/man-pages/man1/ipcs.1.html
https://www.thegeekstuff.com/2010/08/ipcs-command-examples/