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 partition
FROM TABLE(MON_GET_CONTAINER('',-2)) as sc
WHERE (sc.tbsp_name = 'BF_TBSP_TEST')
ORDER BY SC.DBPARTITIONNUM, SC.CONTAINER_ID
FOR READ ONLY WITH UR
Stack 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)