Jeff,
What is the current version of Omnidex that you are using? Also, are you into Jumbo land with some of the data sets?
Thanks,
Tom Renz
>>> Jeff Mikolai <[log in to unmask]> 07/07/99 11:36AM >>>
Note: Some recipients have been dropped due to syntax errors.
Please refer to the "$AdditionalHeaders" item for the complete headers.
I am having an issue with reindexing one of my databases. Any ideas?
JOB CNBAIN31,MGR.UBID,PUB.
Priority = DS; Inpri = 8; Time = UNLIMITED seconds.
Job number = #j1141.
WED, JUL 7, 1999, 10:07 AM.
HP3000 Release: C.55.00 User Version: C.55.00
MPE/iX HP31900 C.05.08 Copyright Hewlett-Packard 1987.
All rights reserved.
STREAMED BY MGR.UBID (#S2412) ON LDEV# 354
STREAM DATE: WED, JUL 7, 1999, 10:07 AM
Welcome to HourGlass 2000 for the HP 3000!
Version 98W
WED, JUL 7, 1999, 10:07 AM
* Loading Macs II Software from: UBID Version: 3.130 1/29/99
* Copyright 1990,91,92,93,94,95 Smith-Gardner & Associates
THIS TERMINAL IS LOGGED ON AS MGR's TERMINAL
:SETDUMP
:COMMENT
:COMMENT ******************************************
:COMMENT Modified: THUR, MAR 7, 1997
:COMMENT
:COMMENT CNBASIN5 is an installation JOB stream
:COMMENT generated for an existing Omnidex-enhanced
:COMMENT database. It can be used to reinstall
:COMMENT OMNIDEX on the database, as an archival
:COMMENT copy of the JOB, or just to see how OMNIDEX
:SETJCW NBDISABLE FATAL
:COMMENT is installed on your database.
:COMMENT ******************************************
:COMMENT
:COMMENT ******************************************
:COMMENT MODIFIED 3/31/97 - CREATED FOR MACSII v205
:COMMENT ******************************************
:COMMENT
:COMMENT 07/03/97 PNL O00037401-00 Modified job card line to
:COMMENT allow streaming thru SGSTREAM
:COMMENT 05/27/98 PNL P00060420-02 Add new key in BILLINGS set
:COMMENT LAST-FULL-ORD-NO
:COMMENT 10/28/98 PNL XXXXXXXXXXXX Renamed for v.3.1xx
:COMMENT *********************************************************
:
:CHGROUP MACSDATA
:
:RUN DBINSTAL.PUB.DISC300;XL='XLOMNIDX.PUB.SYS'
DS76004.3.04 Omnidex IMS DBINSTAL Wed Jul 7 1999 13:07:45
(C) Dynamic Information Systems Corp. 1981
Data base name: CNBASE.MACSDATA;MODE=5
Cmd: SET TPI OFF
TurboIMAGE TPI disabled
Cmd: Z!
PURGE root and all index files? Y
Purge complete
Cmd: QUIT
END OF PROGRAM
:RESET @
:SETJCW CIERROR = 0
:CONTINUE
:RUN OMNIUTIL.PUB.DISC300;INFO='-T';XL='XLOMNIDX.PUB.SYS'
OmniUtil/MPEiX for TurboImage WED, JUL 7, 1999, 10:07 AM
(C) Dynamic Information Systems Corp. 1997
Omnidex Maintenance Utility Program
OMNIUTIL: INSTALL CNBASE.MACSDATA READONLY
OMNIUTIL:
OMNIUTIL: TABLE PROG-CUSTOMER
OMNIUTIL: CREATE CUST-PROG SORTED
OMNIUTIL:
OMNIUTIL: TABLE BILLINGS
OMNIUTIL: CREATE LAST-FULL-ORD-NO SORTED
OMNIUTIL:
OMNIUTIL: TABLE EFFORTS
OMNIUTIL: CREATE LAST-FULL-ORD-NO SORTED
OMNIUTIL:
OMNIUTIL: TABLE ATTRITION
OMNIUTIL: CREATE SOURCE SORTED
OMNIUTIL: CREATE UPDATE-KEY SORTED
OMNIUTIL:
OMNIUTIL: TABLE CN-PROCESSING
OMNIUTIL: CREATE FULL-ORDER-NO SORTED
OMNIUTIL:
OMNIUTIL: TABLE COL-PAY-UP
OMNIUTIL: CREATE SOURCE SORTED
OMNIUTIL: CREATE UPDATE-KEY-44 SORTED
OMNIUTIL:
OMNIUTIL: ACTIVATE
Warning: Database is accessed in read mode.
Please wait, creating index structures.
DS76004.3.04 Omnidex IMS DBINSTAL Wed Jul 7 1999 13:07:48
(C) Dynamic Information Systems Corp. 1981
Data base name: CNBASE.MACSDATA;MODE=5
Cmd: INSTALL
OMNIDEX INSTALLATION:
Designate tables and fields for KEYWORD retrieval.
Type / to stop; type ? for help.
Table name? //
Designate tables and fields for SORTED KEY retrieval.
Type / to stop; type ? for help.
Table name? PROG-CUSTOMER
Enter the name of each IMSAM key. To specify a composite key,
follow the key's name with a '!'. Type / to stop.
Key field: CUST-PROG
Key field: //
Table name? BILLINGS
Enter the name of each IMSAM key. To specify a composite key,
follow the key's name with a '!'. Type / to stop.
Key field: LAST-FULL-ORD-NO
Key field: //
Table name? EFFORTS
Enter the name of each IMSAM key. To specify a composite key,
follow the key's name with a '!'. Type / to stop.
Key field: LAST-FULL-ORD-NO
Key field: //
Table name? ATTRITION
Enter the name of each IMSAM key. To specify a composite key,
follow the key's name with a '!'. Type / to stop.
Key field: SOURCE
Key field: UPDATE-KEY
Key field: //
Table name? CN-PROCESSING
Enter the name of each IMSAM key. To specify a composite key,
follow the key's name with a '!'. Type / to stop.
Key field: FULL-ORDER-NO
Key field: //
Table name? COL-PAY-UP
Enter the name of each IMSAM key. To specify a composite key,
follow the key's name with a '!'. Type / to stop.
Key field: SOURCE
Key field: UPDATE-KEY-44
Key field: //
Table name? //
Use the Build command to load the following indexes:
PROG-CUSTOMER;CUST-PROG
BILLINGS;LAST-FULL-ORD-NO
EFFORTS;LAST-FULL-ORD-NO
ATTRITION;SOURCE
ATTRITION;UPDATE-KEY
CN-PROCESSING;FULL-ORDER-NO
COL-PAY-UP;SOURCE
COL-PAY-UP;UPDATE-KEY-44
Installation complete.
Cmd:
Installation is complete.
OMNIUTIL: EXIT
END OF PROGRAM
:IF CIERROR <> 0 THEN
*** EXPRESSION FALSE: COMMANDS IGNORED UNTIL MATCHING ELSEIF/ELSE
/ENDIF
: SHOWJCW
: TELL MGR.!HPACCOUNT; !HPJOBNAME: Installation Failed !!!
: EOJ
:ELSE
*** RESUME EXECUTION OF COMMANDS
: TELL MGR.!HPACCOUNT; !HPJOBNAME: Installation completed.
:RESET @
:SETJCW CIERROR = 0
:CONTINUE
:RUN OMNIUTIL.PUB.DISC300;INFO='-T';XL='XLOMNIDX.PUB.SYS'
OmniUtil/MPEiX for TurboImage WED, JUL 7, 1999, 10:07 AM
(C) Dynamic Information Systems Corp. 1997
Omnidex Maintenance Utility Program
OMNIUTIL: MODIFY CNBASE.MACSDATA
OMNIUTIL: INDEX ALL
OMNIUTIL: ACTIVATE
Please wait, reindexing the keys.
**** Data memory protection trap (TRAPS 68).
ABORT: OMNIUTIL.PUB.DISC300
PC=208.00fb25c4 _wrtchk+$c
NM* 0) SP=41849890 RP=208.00fb2ae8 fprintf+$1c
NM 1) SP=41849850 RP=208.00fb2ab8 ?fprintf+$8
export stub: e51.00022bf8 fwrite_text+$1c
NM 2) SP=41849810 RP=e51.0002c0a8 create_dbinstal_files+$74
NM 3) SP=418497d0 RP=e51.00026518 reindex_omnidex+$60
NM 4) SP=41849790 RP=e51.00026b54 online_reindex+$16c
NM 5) SP=41849510 RP=e51.000317c4 parse_activate_keyword+$2d4
NM 6) SP=41849490 RP=e51.000343a0 process_command+$220
NM 7) SP=41849410 RP=e51.00034508 run_command_mode+$a4
NM 8) SP=41849390 RP=e51.00022ab4 main+$208
NM 9) SP=418473d0 RP=e51.0005e0d8 _start+$7c
NM a) SP=41847310 RP=e51.00016134 $START$+$1c
NM b) SP=418461b0 RP=e51.00000000
(end of NM stack)
R0 =00000000 40100420 00fb2aeb 00000000 R4 =41849444 41849660 4163e398
41849578
R8 =00000000 00000000 00000000 00000000 R12=00000000 00000000 00000000
00000000
R16=00000000 00000000 00000000 00000000 R20=00000208 00fb2ab0 41849664
00000143
R24=4163a5f0 41638ec0 00000000 416e8000 R28=00000000 00000000 41849890
00022bfb
IPSW=0004000f=jthlnxbCvmrQPDI PRIV=3 SAR=0007 PCQF=208.fb25c7
208.fb25cb
SR0=0000000a 00000000 00000000 00000000 SR4=00000208 000005c9 0000000b
0000000a
TR0=189ee02f 00627ff8 008304c8 87590000 TR4=d3c0b734 4184a8e0 00219374
0000000f
PID1=0616=030b(W) PID2=0000=0000(W) PID3=0000=0000(W)
PID4=0000=0000(W)
RCTR=00000000 ISR=00000208 IOR=0000000c IIR=0f581059 IVA=00d67000
ITMR=7998d46f
EIEM=ffffffff EIRR=00000000 CCR=00c0
Program terminated in an error state. (CIERR 976)
:IF CIERROR <> 0 THEN
*** EXPRESSION TRUE
: SHOWJCW
CIERROR = 976
JCW = SYSTEM137
SECURITYANSWER = 0
SPOOLPACKET = 1024
SPOOLACKFREQ = 1
MPEXALTFILEKEEPAMDATES = 1
MPEXCOPYKEEPAMDATES = 1
NBDISABLE = FATAL0
CJCW = 0
FSERROR = 0
: TELL MGR.!HPACCOUNT; !HPJOBNAME: Indexing Failed !!!
: EOJ
[CNBAIN31 MGR UBID 99/07/07 10:08 00000005 00000016 MGR.UBID
J]Log.
:ELSE
*** COMMANDS IGNORED UNTIL MATCHING ENDIF
:RUN DBINSTAL.PUB.DISC300;XL='XLOMNIDX.PUB.SYS'
CNBASE
SET TPION
E
:RUN DBUTIL.PUB.SYS
SET CNBASE CIUPDATE=ON
RELEASE CNBASE
E
: TELL MGR.!HPACCOUNT; !HPJOBNAME: Indexing completed.
: TELLOP; !HPJOBNAME: Indexing completed.
:ENDIF
*** RESUME EXECUTION OF COMMANDS
:IF CIERROR > 1609 AND CIERROR < 1628 THEN
*** EXPRESSION FALSE: COMMANDS IGNORED UNTIL MATCHING ELSEIF/ELSE
/ENDIF
: COMMENT - TELL Message failed
: SHOWJCW
: SETJCW CIERROR=0
:ENDIF
*** RESUME EXECUTION OF COMMANDS
:EOJ
[CNBAIN31 MGR UBID 99/07/07 10:08 00000006 00000017 MGR.UBID
J]Log.
CPU sec. = 6. elapsed min. = 1. WED, JUL 7, 1999, 10:08 AM.
|
