Return
-
Title
IBM.Data.DB2.DB2Exception: ERROR [42703] [IBM][DB2/AIX64] "SC.DBPARTITIONNUM" is not valid in the context where it is used. -
Description
Trying to create a TABLESPACE , one gets the error:
IBM.Data.DB2.DB2Exception: ERROR [42703] [IBM][DB2/AIX64] "SC.DBPARTITIONNUM" is not valid in the context where it is used.Stack trace: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)Outer exception:System.ApplicationException: ERROR [42703] [IBM][DB2/AIX64] "SC.DBPARTITIONNUM" is not valid in the context where it is used.Query:SELECT tbsp_name as tablespace_name, container_name, container_type, total_pages, usable_pages, accessible, stripe_set, -1 AS partitionFROM TABLE(MON_GET_CONTAINER('',-2)) as scWHERE (sc.tbsp_name = 'BF_TBSP_TEST')ORDER BY SC.DBPARTITIONNUM, SC.CONTAINER_IDFOR READ ONLY WITH URStack trace: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)
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.