Solved

Question about db2 error

Posted on 2014-02-13
1
685 Views
Last Modified: 2014-02-14
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
Comment
Question by:corgano
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 45

Accepted Solution

by:
Kent Olsen earned 300 total points
ID: 39858125
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

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial will demonstrate how to add subdomains to your content reports. This can be very importing in having a site with multiple subdomains.
This Micro Tutorial will demonstrate how nuggets on the Web are formatted by using Chrome Developer Tools. These tools would not only view the site's CSS but it can also modify it and save the CSS to use on your own site.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question