DYNAMIC STATEMENT SPACE - SQLCODE=-904

Steve Reznikov

DYNAMIC STATEMENT SPACE - SQLCODE=-904

Hi All,

Several days ago one of our applications started getting SQLCODE=-904 . Here is the entire error message:

Error: DB2 SQL Error: SQLCODE=-904, SQLSTATE=57011, SQLERRMC=00E7910D;00000603;DYNAMIC STATEMENT SPACE, DRIVER=3.58.81

SQLState:  57011

ErrorCode: -904

Error: DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=3.58.81

SQLState:  26501

ErrorCode: -514

 

After some poking around we realized that we exceeded our Dynamic Statement Cache Storage limit. To mitigate the issue we increased the size of the CACHE_DEP_TRACK_STOR_LIM ZPARM.

The question is, has anyone else experienced this issue? How do you monitor the size of the DSC Storage? There was no message in DB2*MSTR indicating that there was an issue with the Storage. 

Thanks.

Missy Case

DYNAMIC STATEMENT SPACE - SQLCODE=-904
(in response to Steve Reznikov)
Steve,
We ran into this recently as well. It’s a hidden parm & we needed IBM to help us unravel the errors, but – it’s odd – I’d never heard of it, now twice in a month!

[cid:[login to unmask email] http://www.wipro.com

Melissa (Missy) Case

GIS Team Leader / DB2 Database Administrator 3

Wipro Limited









From: Steve Reznikov [mailto:[login to unmask email]
Sent: Friday, August 4, 2017 8:16 AM
To: [login to unmask email]
Subject: [DB2-L] - DYNAMIC STATEMENT SPACE - SQLCODE=-904


** This mail has been sent from an external source. Treat hyperlinks and attachments in this email with caution**

Hi All,

Several days ago one of our applications started getting SQLCODE=-904 . Here is the entire error message:

Error: DB2 SQL Error: SQLCODE=-904, SQLSTATE=57011, SQLERRMC=00E7910D;00000603;DYNAMIC STATEMENT SPACE, DRIVER=3.58.81

SQLState: 57011

ErrorCode: -904

Error: DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=3.58.81

SQLState: 26501

ErrorCode: -514



After some poking around we realized that we exceeded our Dynamic Statement Cache Storage limit. To mitigate the issue we increased the size of the CACHE_DEP_TRACK_STOR_LIM ZPARM.

The question is, has anyone else experienced this issue? How do you monitor the size of the DSC Storage? There was no message in DB2*MSTR indicating that there was an issue with the Storage.

Thanks.

-----End Original Message-----

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
Attachments

  • image001.jpg (3k)

Steve Reznikov

RE: DYNAMIC STATEMENT SPACE - SQLCODE=-904
(in response to Missy Case)

Missy,

What I personally didn't like is that there was nothing about this error in DB2 logs.

We increased the zparm value to resolve the issue, but we couldn't find the answer on how to monitor the usage going forward. Hopefully someone in this forum knows ho to do this.

Steve.

Graham Clarke

RE: DYNAMIC STATEMENT SPACE - SQLCODE=-904
(in response to Steve Reznikov)

We hit this problem about 12 months ago. Have a look at information APAR II14811 which gives some clues about what is happening.

 

Graham