Topic
2 replies Latest Post - ‏2011-12-10T13:01:45Z by jmueller
jmueller
jmueller
26 Posts
ACCEPTED ANSWER

Pinned topic Unable to drop schema

‏2011-11-30T20:22:16Z |
Hello Optim PM-Team,

After installing a new defined PM and configure monitoring for our first database
following error occured:

CDPMA1114E:
Eine Repository-Serveroperation ist fehlgeschlagen. Details: PEConfigGUI.postDB2PMSteps() ist mit Fehlercode/Nachricht=1112
An error occurred when creating tables in repository database : Unable to drop schema 'DB2PMP', details: DB2 SQL Error: SQLCODE=-478, SQLSTATE=42893, SQLERRMC=SCHEMA;DB2PMP.IHS1_CAT_ID;INDEX, DRIVER=3.62.56, SQLState=<42893>, ErrorCode=<-478>. SQLCA=<DROP, ALTER, TRANSFER OWNERSHIP or REVOKE on object type "SCHEMA" cannot be processed because there is an object "DB2PMP.IHS1_CAT_ID", of type "INDEX", which depends on it.. SQLCODE=-478, SQLSTATE=42893, DRIVER=3.62.56>.
An error occurred when creating tables in repository database : Unable to drop schema 'DB2PMP', details: DB2 SQL Error: SQLCODE=-478, SQLSTATE=42893, SQLERRMC=SCHEMA;DB2PMP.IHS1_CAT_ID;INDEX, DRIVER=3.62.56, SQLState=<42893>, ErrorCode=<-478>. SQLCA=<DROP, ALTER, TRANSFER OWNERSHIP or REVOKE on object type "SCHEMA" cannot be processed because there is an object "DB2PMP.IHS1_CAT_ID", of type "INDEX", which depends on it.. SQLCODE=-478, SQLSTATE=42893, DRIVER=3.62.56>. fehlgeschlagen.

Why the transaction will drop the schema?

Environment:
instance name: db2pmp
database name: pmp

OPM: 4.1.1.0

db2pmp@r2l04
[/db2/db2pmp]> db2level
DB21085I Instance "db2pmp" uses "64" bits and DB2 code release "SQL09075" with
level identifier "08060107".
Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23285", and Fix Pack
"5".
Product is installed at "/opt/IBM/OPM/V9.7".
db2pmp@r2l04
[/db2/db2pmp]> oslevel -s
7100-00-03-1115

I have been unable to determine exactly what this exception indicates and how to resolve it. Any help would be greatly appreciated.

Best regards,
Joachim
Updated on 2011-12-10T13:01:45Z at 2011-12-10T13:01:45Z by jmueller
  • UteBaumbach
    UteBaumbach
    55 Posts
    ACCEPTED ANSWER

    Re: Unable to drop schema

    ‏2011-12-02T00:33:56Z  in response to jmueller
    Hello,
    please apply APAR IC78940 which solves that problem. The problem is caused by using a similar instance name as the schema name within the repository database.
    Alternatively as a workaround you can drop the listed indexes manually.

    Regards
    Ute Baumbach
    • jmueller
      jmueller
      26 Posts
      ACCEPTED ANSWER

      Re: Unable to drop schema

      ‏2011-12-10T13:01:45Z  in response to UteBaumbach
      Hello Ute,

      Problem solved after applying APAR IC78940. Thank you.

      After configuring some database I will migrate next week to 5.1.

      Best regards,
      Joachim Müller