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
Solved

Question about db2 error

Posted on 2014-02-13
1
660 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
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
CSS not updating in FF and ipad 6 78
Who uses Outlook dot com for e-mail (the former Hotmail) 19 77
download a file from webmail to ipod 2 61
IE 11 + long running scripts 3 74
I recently found myself in a Corporate Situation where the client had requested blocking access to any and all websites except his own Domain? Easy? I am sure this would be your answer but their requirement was, this has to be done without using…
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
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.
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

809 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