Posted: Fri Jun 20, 2008 10:53 am Post subject: Runstats for a Z/os DB2 table via DB2 command line processor
Hi,
I am trying to perform the runstats for a DB2 O/s table thru the Db2 Command line processor as follows but I am getting an error.
db2 => RUNSTATS ON TABLE AZ.TEST1 AND SAMPLED DETAILED INDEXES ALL
SQL2310N The utility could not generate statistics. Error "-30073" was
returned.
I am debugging this error but wanted to findout whether it is possible Runstats for DB2 Z/os table thru DB@ CLP. Can anyone throw some light on this please ?
My actual requirement is to execute the RUNSTATS from Informatica Command task for this table. When I was testing from Informatica I got an error then I tried to do this from the DB2 CLP to find out whether it's possible via the CLP or not.
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Fri Jun 20, 2008 11:13 am Post subject:
SMS,
Code:
SQL30073N " " Parameter value " "
is not supported.
Explanation: The remote database received data it does not
recognize. The current environment command or SQL statement
cannot be processed successfully, nor can any subsequent commands
or SQL statements.
The current transaction is rolled back and the application is
disconnected from the remote database. The command cannot be
processed.
User Response: Record the message number (SQLCODE) and the
parameter identifier. Record all error information from the
SQLCA, if possible. Attempt to connect to the remote database
and rerun the application.
If sufficient memory resources exist and the problem continues,
If trace was active, invoke the Independent Trace Facility at the
operating system command prompt. Refer to the Independent Trace
Facility in the Troubleshooting Guide for information on how to
use this facility. Contact your technical service representative
with the following information:
Required information:
o Problem description
o SQLCODE, parameter identifier, and value
o SQLCA contents if possible
o Trace file if possible.
Some possible parameter identifiers include:
002F The target server does not support the data type requested
by the application requester. For example, when DB2 Connect is
used to connect to DB2 2.3, this error will be returned unless
the proper PTF is applied to DB2 2.3. Ensure that the level of
the server is supported by the requester.
119C, 119D, 119E The target server does not support the CCSID
requested by the application requester. Ensure the CCSID used by
the requester is supported by the server.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
