Hello Listers,
All the tables of schema SYSCATV82, appears to exist but you can't query
it?
db2 Info : db2 v8.2 - Aix 5.2
Ex :
db2 describe table SYSCATV82.SNAPCONT
Column Type Type
name schema name Length Scale
Nulls
------------------------------ --------- ------------------ -------- -----
------
SNAPSHOT_TIMESTAMP SYSIBM TIMESTAMP 10 0
Yes
TBSP_NAME SYSIBM VARCHAR 128 0
Yes
TBSP_ID SYSIBM BIGINT 8 0
Yes
CONTAINER_NAME SYSIBM VARCHAR 256 0
Yes
CONTAINER_ID SYSIBM BIGINT 8 0
Yes
CONTAINER_TYPE SYSIBM SMALLINT 2 0
Yes
TOTAL_PAGES SYSIBM BIGINT 8 0
Yes
USABLE_PAGES SYSIBM BIGINT 8 0
Yes
ACCESSIBLE SYSIBM SMALLINT 2 0
Yes
STRIPE_SET SYSIBM BIGINT 8 0
Yes
DBPARTITIONNUM SYSIBM SMALLINT 2 0
Yes
11 record(s) selected.
db2 "select count(*) from SYSCATV82.SNAPCONT"
SQL1042C An unexpected system error occurred. SQLSTATE=58004
Thanks,
Mrinal (Mac)
http://www.rac.co.uk
http://www.rac.co.uk/business
http://www.bsm.co.uk
Any opinions expressed in this e-mail are those of the individual and not necessarily the company. This e-mail and any attachments are confidential to RAC and/or BSM and are solely for use by the intended recipient.
If you are not the intended recipient you must not disclose, copy or distribute its contents to any other person nor use its contents in any way.
If you have received this e-mail in error please forward a copy of this e-mail to "[Email address protected]
RAC Motoring Services: Registered England 1424399
VAT Reg No. GB 238640945
British School of Motoring Limited: Registered England 291902
VAT Reg No. GB 239505847
RAC Financial Services Limited: Registered England & Wales 5171817
VAT Reg No. GB 238640945
Registered Office(s): 8 Surrey Street, Norwich, NR1 3NG
RAC Motoring Services and RAC Financial Services Limited are authorised and regulated by the Financial Services Authority, both companies are members of the Aviva group.
This e-mail and any attachments has been scanned for the presence of computer viruses. RAC/BSM accept no responsibility for computer viruses once this e-mail has been transmitted.
DB2 & UDB email list listserv db2-l LazyDBA home page