Skip to main content
Delphix

KBA1739 DB2 dSource Link Failure: SQL0930N There is Not Enough Storage Available to Process the Statement

 

 

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