?
Solved

Question about db2 error

Posted on 2014-02-13
1
Medium Priority
?
724 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 46

Accepted Solution

by:
Kent Olsen earned 1200 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

I spend far too much time on the web keeping up with the news: politics, the environment, computer stuff, the Experts Exchange. It's never-ending. But many of the most informative web pages are overwhelmed with noise: scrolling banners, flashing tex…
Do you come here a lot? Are you lazy like me and don't want to go through the "trouble" of having to click your Dock's Safari icon and then having to click your Experts Exchange Favorites bookmark to get here? Well then this article is for you.
Google currently has a new report that is in beta and coming soon to Webmaster Tool accounts. This Micro Tutorial will highlight new features for Google Webmaster Tools.
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch your Bookmark Menu: Press 'Ctrl +…

777 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