Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 860
  • Last Modified:

Question about db2 error

I believe this error is due to a resource issue in db2 but I wanted to confirm:

db2 sql error: sqlcode=-973, sqlstate=57011, sqlerrmc=pckcachesz, driver=3.53.95
0
corgano
Asked:
corgano
1 Solution
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi Corgano,

Yes, it's a resource shortage error.  IBM has a very good writeup on the steps to correct this on their online help:

  http://publib.boulder.ibm.com/infocenter/tivihelp/v4r1/index.jsp?topic=%2Fcom.ibm.tpc_V411.doc%2Ffqz0_r_tbs_db2_sql_973.html

Essentially, you need to do three things

  db2 connect to {yourdatabase}
  db2 get db cfg show detail | grep PCKCACHESZ

Increase PCKCACHESZ by 10% of the current size.

  db2 update db cfg for TPCDB using PCKCACHESZ NEW_VALUE

If the error continues, repeat those steps.  Note that grep is a unix/linux command.  If you're running DB2 on Windows or other operating system you'll need to use the correct command for the O/S.


Good Luck,
Kent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now