IBM Support

II08219: SQLCODE -204 ON DROP TABLE (TABLE EXISTS IN SYSIBM.SYSTABLES)

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as canceled.

Error description

  • DROP TABLE received SQLCODE204
    sqlcode  = -204 , error: vwvdb2.tncbse is an undefined name
    sqlstate = 52004
    sqlerrp  =  dsnxidtb sql procedure detecting error
    sqlerrd  =  72    0     0     1     0    0
    ...
    ...
      select CHILDREN from sysibm.systables showed that the child
    count contains a '6' but there were only 5 related records in
    SYSIBM.SYSRELS.
    ...
       User did not know what lead up to this condition but was able
    to use REPAIR TABLESPACE utility to get the CHILDREN count back
    to 5 and successfully DROP TABLE.
    
    PTM KEW0546 opened for this problem.
    Search arguments: DB2 5740xyr00 r230 r310
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • closed for DB2INFO use
    

APAR Information

  • APAR number

    II08219

  • Reported component name

    PB LIB INFO ITE

  • Reported component ID

    INFOPBLIB

  • Reported release

    001

  • Status

    CLOSED CAN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    1994-09-26

  • Closed date

    1996-04-04

  • Last modified date

    1996-04-04

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 April 1996