Toad World® Forums

TOAD for DB2 z/os 5.2 schema compare error


#1

i recently installed TOAD for DB2 5.2 and when i run the schema compare i’m getting an error. Could you please help. Here is the error i’m getting:

Error mesage: ERROR [42704] [IBM][DB2] SQL0204N “QUEST.QCTEMPLATE_REPO200” is an undefined name.
Query: SELECT * FROM QUEST.QCTEMPLATE_REPO200
where name in (‘QCSORTIN’, ‘QCSORTO’, ‘QCERROR’, ‘QCMAP’, ‘QCDISC’, ‘QCUNLDDN’, ‘QCERROR’, ‘QCSORTIN’, ‘QCSORTO’, ‘QCCPY1’)
FOR READ ONLY WITH UR


Level 1 inner exception (Quest.Compare.Schema.Common.Pl.CNSLoader+ModelThreadException):
Error mesage: ERROR [42704] [IBM][DB2] SQL0204N “QUEST.QCTEMPLATE_REPO200” is an undefined name.
Query: SELECT * FROM QUEST.QCTEMPLATE_REPO200
where name in (‘QCSORTIN’, ‘QCSORTO’, ‘QCERROR’, ‘QCMAP’, ‘QCDISC’, ‘QCUNLDDN’, ‘QCERROR’, ‘QCSORTIN’, ‘QCSORTO’, ‘QCCPY1’)
FOR READ ONLY WITH UR

Call Stack:
at Quest.Compare.Schema.DB2.DBModel.CNS2Loader.FillModel(CNSPLProgress plProgress, LimitationParms dictLimitations, ICNSNode iNode1, ICNSNode iNode2)
at Quest.Compare.Schema.DB2.DBModel.CNS2Loader.FillNodes(CNSPLProgress plProgress, IEnumerable1 idList1, IEnumerable1 idList2, ICNSRootManager rm, QueryParams qp, String goal)
at Quest.Compare.Schema.DB2.DBModel.CNS2RootManager.LoadModelForSchemaCompare(ICommandProgress progress, Boolean needReferences)
at Quest.Compare.Schema.Common.Pl.CNSCmdFillPairTree.CommandExecution(ICommandQueue icmdqueue)
at Quest.Compare.General.Sys.ProgressiveCommand.ExecuteCommand(ICommandQueue icmdqueue)


Level 2 inner exception (System.ApplicationException):
Error mesage: ERROR [42704] [IBM][DB2] SQL0204N “QUEST.QCTEMPLATE_REPO200” is an undefined name.
Query: SELECT * FROM QUEST.QCTEMPLATE_REPO200
where name in (‘QCSORTIN’, ‘QCSORTO’, ‘QCERROR’, ‘QCMAP’, ‘QCDISC’, ‘QCUNLDDN’, ‘QCERROR’, ‘QCSORTIN’, ‘QCSORTO’, ‘QCCPY1’)
FOR READ ONLY WITH UR

Call Stack:
at Quest.Compare.Schema.DB2.DBModel.CNS2Connection.ExecuteReader(String& sQuery, SortedList slParameters, Int32 nTimeout, IDbCommand& iCommand)
at Quest.Compare.Schema.DB2.DBModel.CNS2Loader.DirectExtractFromDB(CNS2Database oDb, CNSPLProgress plProgress, LimitationsPack packLimitations, DirectExtractOption indOptions, String sSnap)
at Quest.Compare.Schema.DB2.DBModel.CNS2Loader.DirectExtract(CNS2Database oDb, CNSPLProgress plProgress, LimitationsPack packLimitations, DirectExtractOption indOptions, String sSnap)
at Quest.Compare.Schema.DB2.DBModel.CNS2Loader.Fill(CNS2Database oDatabase, CNSPLProgress plProgress, LimitationsPack packLimitations)
at Quest.Compare.Schema.DB2.DBModel.CNS2Loader.Fill(ICNSNode iNode, CNSPLProgress plProgress, LimitationsPack idictLimitations)
at Quest.Compare.Schema.DB2.DBModel.CNS2Loader.FillInAnotherThread(Object oFillingThreadParms)


Level 3 inner exception (IBM.Data.DB2.DB2Exception):
ERROR [42704] [IBM][DB2] SQL0204N “QUEST.QCTEMPLATE_REPO200” is an undefined name.
Call Stack:
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation)
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method)
at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
at IBM.Data.DB2.DB2Command.ExecuteReader()
at Quest.Compare.Schema.DB2.DBModel.CNS2Connection.ExecuteReader(String& sQuery, SortedList slParameters, Int32 nTimeout, IDbCommand& iCommand)


#2

Please, verify that you have QUEST.QCTEMPLATE_REPO200 installed.
If not then you should look at documentation how to do it,
zosinstallguide.png


#3

is this new for v5.2 to have to install these db2 objects…i don’t recall installing this in version 5.1 and schema compare worked fine.


#4

Maybe new for Schema Compare,- this is just a requirement for z/OS