BCU DB2 has the following errors:
“There are no pages currently available in bufferpool “4098″ .. when user trying to test run some datastage job:
STAGE_SUB_SEG.0: Fatal Error: Fatal: [IBM][CLI Driver][DB2/LINUXX8664] SQL1218N There are no pages currently available in bufferpool “4098″. SQL STATE=57011
DSTAGE-DB2CLI-0027 .. ‘SQLExecDirect: Error executing statement ‘SELECT DISTINCT ..’
# ipcs -a
—— Shared Memory Segments ——–
key shmid owner perms bytes nattch status
0×00000000 1451720704 db2inst1 767 40169352 1 dest
0×00000000 1452507140 db2inst1 701 131072 1 dest
0×00000000 1453785099 db2inst1 701 131072 1 dest
—— Semaphore Arrays ——–
key semid owner perms nsems
0×0000d431 65536 root 777 1
0×620e2284 32769 root 644 1
0×4d028e78 262146 root 600 8
—— Message Queues ——–
key msqid owner perms used-bytes messages
0×000037a8 0 root 666 0 0
0×73a679fb 1327038465 db2inst1 610 0 0
0×034d3a1c 1327071234 db2inst1 610 0 0
0×02b867d3 1324580875 db2inst1 610 0 0
0×444912ca 1324613651 db2inst1 610 0 0
> free -mo
total used free shared buffers cached
Mem: 29226 21933 7293 0 1008 19776
Swap: 32773 0 32773
> cat /proc/sys/vm/drop_caches
0
# echo 3 > /proc/sys/vm/drop_caches
# free -mo
total used free shared buffers cached
Mem: 29226 299 28927 0 0 64
Swap: 32773 0 32773
After the above change, file system cache dropped from 19776 to 64. And the job runs fine.
Then change the value back:
# echo 0 > /proc/sys/vm/drop_caches