By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,081 Members | 862 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,081 IT Pros & Developers. It's quick & easy.

Getting an error when running table functions - snapshot_tbs

P: n/a
Look below.. I'm baffled - what is going on?

db2 => select tablespace_name from table(snapshot_tbs('epmdev01', -1))
as snapshot_tbs
Do you want to execute the above command ? (y/n) y

TABLESPACE_NAME
--------------------------------------------------------------------------------------------------------------------------------
SQL0443N Routine "SYSPROC.SNAPSHOT_TBS" (specific name
"SNAPSHOT_TBS") has
returned an error SQLSTATE with diagnostic text "DBA7612".
SQLSTATE=38553
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
From the message ref:

DBA7612N
An error has occurred when accessing file.
Explanation:

The possible reasons include:

* File format error
* Communication error
* Memory allocation error when reading from file

User Response:

Fix any format errors in the file. Check the db2diag.log file for more
information to help resolve the communication or memory allocation
errors. Rerun the application.

aa*******@yahoo.com wrote:
Look below.. I'm baffled - what is going on?

db2 => select tablespace_name from table(snapshot_tbs('epmdev01', -1))
as snapshot_tbs
Do you want to execute the above command ? (y/n) y

TABLESPACE_NAME
--------------------------------------------------------------------------------------------------------------------------------
SQL0443N Routine "SYSPROC.SNAPSHOT_TBS" (specific name
"SNAPSHOT_TBS") has
returned an error SQLSTATE with diagnostic text "DBA7612".
SQLSTATE=38553

Nov 12 '05 #2

P: n/a
From the message ref:

DBA7612N
An error has occurred when accessing file.
Explanation:

The possible reasons include:

* File format error
* Communication error
* Memory allocation error when reading from file

User Response:

Fix any format errors in the file. Check the db2diag.log file for more
information to help resolve the communication or memory allocation
errors. Rerun the application.

aa*******@yahoo.com wrote:
Look below.. I'm baffled - what is going on?

db2 => select tablespace_name from table(snapshot_tbs('epmdev01', -1))
as snapshot_tbs
Do you want to execute the above command ? (y/n) y

TABLESPACE_NAME
--------------------------------------------------------------------------------------------------------------------------------
SQL0443N Routine "SYSPROC.SNAPSHOT_TBS" (specific name
"SNAPSHOT_TBS") has
returned an error SQLSTATE with diagnostic text "DBA7612".
SQLSTATE=38553

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.