Troubleshooting
Problem
Why do I receive the error below when trying to run IBM Content Navigator Database Script against Db2 for z/OS database?
SQLCODE = -747, ERROR: TABLE <SCHEMANAME>.CONFIGURATION IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED.
Symptom
The error below is thrown when trying to run IBM Content Navigator database script against Db2 for z/OS database.
SQLCODE = -747, ERROR: TABLE <SCHEMANAME>.CONFIGURATION IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED.
Cause
This error occurs because the IBM Content Navigator CONFIGURATION table has a DBCLOB column which requires an AUXILARY table with an INDEX. IBM Content Navigator script is missing the statements to create the required LOB table space, the AUXILARY table and INDEX causing the error.
Environment
IBM Content Navigator with configuration database running on Db2 for z/OS.
Diagnosing The Problem
Review the error thrown by Db2 for z/OS when the create table statement is executed to create IBM Content Navigator CONFIGURATION table.
Resolving The Problem
Create the required objects for a LOB table on Db2 for z/OS prior to executing the create table statement for IBM Content Navigator CONFIGURATION table.
Here is an example of what needs to be created.
CREATE LOB TABLESPACE CONFIGURATIONTS IN <DbName> LOG NO
CREATE AUXILIARY TABLE CONFIGURATIONAUX IN <DbName>.CONFIGURATIONTS STORES CONFIGURATION COLUMN ATTRIBUTES
CREATE UNIQUE INDEX CONFIGINDEX ON CONFIGURATIONAUX
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB18","label":"Miscellaneous LOB"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEUEX","label":"IBM Content Navigator"},"ARM Category":[{"code":"a8m0z0000001guTAAQ","label":"ICN->Deploy"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB18","label":"Miscellaneous LOB"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEUEX","label":"IBM Content Navigator"},"ARM Category":[{"code":"a8m0z0000001guTAAQ","label":"ICN->Deploy"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB18","label":"Miscellaneous LOB"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEUEX","label":"IBM Content Navigator"},"ARM Category":[{"code":"a8m0z0000001guTAAQ","label":"ICN->Deploy"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Product Synonym
ICN, Content Navigator
Was this topic helpful?
Document Information
Modified date:
19 July 2021
UID
ibm16473599