(350) Build up indexes from AS400 logical files

If you have logical files on the AS400 and want to build up indexes on the target PC database from these logical files, take command option 5. QMirror/DB takes the index keys out of the AS400 logical fields and inserts them into system table QMIRROR.ZTBSQL to build up indexes. Only the tables in the system table QMIRROR.ZAMTBF will be affected.

View definitions on the AS400 are also imported into system table QMIRROR.ZTBSQL. Since the view creation syntax is different between AS400 and PC databases, you can modify the statements in column ZTBSQL.ZQSQL to adopt the SQL syntax on the target database.

Buildup indexes from AS400 logical files – Enter AS400 library name: (LIBR1/q) libr1 Buildup indexes from AS400 logical files in library LIBR1 (y/N/q) y 20xx/xx/xx 11:41:05 Buildup indexes from AS400 logical files in library LIBR1 20xx/xx/xx 11:41:05 This may take minutes … 20xx/xx/xx 11:41:14 LIBR1.FCOA; CREATE INDEX LF_FCOA2 ON LIBR1.FCOA1 (FC02) 20xx/xx/xx 11:41:14 LIBR1.FCOA; CREATE INDEX LF_FCOA2 ON LIBR1.FCOA2 (FC22) 20xx/xx/xx 11:41:14 End of buildup indexes from AS400 logical files. Buildup indexes from AS400 logical files – Enter AS400 library name: (LIBR1/q) q

To activate specified indexes, set the column ZQSTS to ‘’ in the system table QMIRROR.ZTBSQL. To omit the specified indexes, set the column ZQSTS to ‘X’ in the system table QMIRROR.ZTBSQL.

For data replication performance consideration, the indexes on the target PC database only build up when the delay is under 60 seconds.

Previous (340) Build up table list from AS400 physical files
Next (360) Start / End AS400 journaling by QMirror/DB