We have a user who's creating indexes on a zero-record table; just to have them available at the start. When she runs this command she gets an error that says:
000 tsql ABEND: signal 11
Creating unique index idxrtblsnapshotx_DOCID
002 Can't open KDBF file /home/database01/558/tblmytable/idxmtblsnapshotx_D.btr for writing: error 2: No such file or directory
002 Can't open KDBF file /home/database01/558/tblmytable/idxmtblsnapshotx_T.btr for writing: error 2: No such file or directory
It's when she runs this that she has trouble:
tsql -q "set keepnoise='on'; set delexp=0; set addexp='\punct{1,5}'; set addexp='\alnum{1,99}'; set addexp='>>\alpha{1,50},=\alpha{1,50}'; create metamorph inverted index idxmtblsnapshotx on tblmytable(DOCID\ BEGBATES\ ENDBATES\ BEGATTACH\ ENDATTACH\ PARENTDOCID\ SF_GROUP_ID\ SF_DOCUMENT_ID\ CASE_NAME\ DESCRIPTION\ SF_DESC\ HISTORY\ DOCUMENT_TYPE\ DOCUMENT_DATE\ PAGES\ ATTPAGES\ ISSUE\ CONTACT_NAME\ DEPT_NAME\ GLOBALDESIGNATION\ DOCTEXT\ AUTHOR\ ADDRESSEE\ COPYEE\ CLAIM_NUMBER\ BOX_NUMBER\ EXHIBIT_NO\ EMPLOYEE_TITLE\ WITNESS_NAME\ WITNESS_TYPE\ VIDEO\ MARGINALIA\ STATUS_MESSAGE\ CONF_STATEMENT\ IMAGE_DOC_ID\ DATE_LAST_MODIFIED\ OPER_LAST_MODIFIED\ CD_VOL\ UPDATEDATE\ DELDATE\ LOADDATE\ LFILE\ TABLE_NAME\ BATES_PREFIX\ BEGIN_BATES_NUM\ BEGIN_BATES_SUFFIX\ BOOKMARK_DATE\ BOOKMARK_DESC\ BOOKMARK_EXISTS\ BOOKMARK_NAME\ BOOKMARK_PAGE\ BOOKMARK_USER\ DATE_INTEGER\ DATE_QUALIFIER\ DELETE_FLAG\ DATE_ADDED\ END_BATES_NUM\ END_BATES_SUFFIX\ FT_SFNAME\ ID\ INTERROGATORY_RFP\ LEGACY_DOCID\ LIP\ PAGE_DATA_1\PAGE_DATA_2\ PAGE_DATA_3\PHOTOGRAPH_GRAPHIC\ PRIVILEGED\ PROD_AWP_DESC\ PROD_AWP_FLAG\ PROD_CONF_DESC\ PROD_CONF_FLAG\ PROD_NR_DESC\ PROD_NR_FLAG\ PROD_OTHER_DESC\ PROD_OTHER_FLAG\ PROD_PRIV_DESC\ PROD_PRIV_FLAG\ PRODUCE_CONF_D\ PRODUCE_CONF_F\ PRODUCE_FLAG\ PRODUCE_FLEX1_D\ PRODUCE_FLEX1_F\ PRODUCE_FLEX2_D\ PRODUCE_FLEX2_F\ PRODUCE_OTHER_D\ PRODUCE_OTHER_F\ PSN_BEGIN\ PSN_BEGIN_SUFFIX\ PSN_END\ PSN_END_SUFFIX\ PSN_PREFIX\ REDACTED_IMAGE_LINK\ REDACTED_FLAG\ RESPONSIVE\ SIP\ TRIAL_EXH_NUM);"
Any idea what's up? The directories mentioned above *do* exist, in fact.
000 tsql ABEND: signal 11
Creating unique index idxrtblsnapshotx_DOCID
002 Can't open KDBF file /home/database01/558/tblmytable/idxmtblsnapshotx_D.btr for writing: error 2: No such file or directory
002 Can't open KDBF file /home/database01/558/tblmytable/idxmtblsnapshotx_T.btr for writing: error 2: No such file or directory
It's when she runs this that she has trouble:
tsql -q "set keepnoise='on'; set delexp=0; set addexp='\punct{1,5}'; set addexp='\alnum{1,99}'; set addexp='>>\alpha{1,50},=\alpha{1,50}'; create metamorph inverted index idxmtblsnapshotx on tblmytable(DOCID\ BEGBATES\ ENDBATES\ BEGATTACH\ ENDATTACH\ PARENTDOCID\ SF_GROUP_ID\ SF_DOCUMENT_ID\ CASE_NAME\ DESCRIPTION\ SF_DESC\ HISTORY\ DOCUMENT_TYPE\ DOCUMENT_DATE\ PAGES\ ATTPAGES\ ISSUE\ CONTACT_NAME\ DEPT_NAME\ GLOBALDESIGNATION\ DOCTEXT\ AUTHOR\ ADDRESSEE\ COPYEE\ CLAIM_NUMBER\ BOX_NUMBER\ EXHIBIT_NO\ EMPLOYEE_TITLE\ WITNESS_NAME\ WITNESS_TYPE\ VIDEO\ MARGINALIA\ STATUS_MESSAGE\ CONF_STATEMENT\ IMAGE_DOC_ID\ DATE_LAST_MODIFIED\ OPER_LAST_MODIFIED\ CD_VOL\ UPDATEDATE\ DELDATE\ LOADDATE\ LFILE\ TABLE_NAME\ BATES_PREFIX\ BEGIN_BATES_NUM\ BEGIN_BATES_SUFFIX\ BOOKMARK_DATE\ BOOKMARK_DESC\ BOOKMARK_EXISTS\ BOOKMARK_NAME\ BOOKMARK_PAGE\ BOOKMARK_USER\ DATE_INTEGER\ DATE_QUALIFIER\ DELETE_FLAG\ DATE_ADDED\ END_BATES_NUM\ END_BATES_SUFFIX\ FT_SFNAME\ ID\ INTERROGATORY_RFP\ LEGACY_DOCID\ LIP\ PAGE_DATA_1\PAGE_DATA_2\ PAGE_DATA_3\PHOTOGRAPH_GRAPHIC\ PRIVILEGED\ PROD_AWP_DESC\ PROD_AWP_FLAG\ PROD_CONF_DESC\ PROD_CONF_FLAG\ PROD_NR_DESC\ PROD_NR_FLAG\ PROD_OTHER_DESC\ PROD_OTHER_FLAG\ PROD_PRIV_DESC\ PROD_PRIV_FLAG\ PRODUCE_CONF_D\ PRODUCE_CONF_F\ PRODUCE_FLAG\ PRODUCE_FLEX1_D\ PRODUCE_FLEX1_F\ PRODUCE_FLEX2_D\ PRODUCE_FLEX2_F\ PRODUCE_OTHER_D\ PRODUCE_OTHER_F\ PSN_BEGIN\ PSN_BEGIN_SUFFIX\ PSN_END\ PSN_END_SUFFIX\ PSN_PREFIX\ REDACTED_IMAGE_LINK\ REDACTED_FLAG\ RESPONSIVE\ SIP\ TRIAL_EXH_NUM);"
Any idea what's up? The directories mentioned above *do* exist, in fact.