Table of Contents

Search

  1. Preface
  2. Introduction
  3. Servers
  4. Console Client
  5. Search Clients
  6. Table Loader
  7. Update Synchronizer
  8. Globalization
  9. Siebel Connector
  10. Web Services
  11. ASM Workbench
  12. System Backup and Restore
  13. Batch Utilities

Starting

Starting

Console

To start the Table Loader, click the
System
Load IDT
. Select a
Loader-Definition
from the drop-down list. Progress messages from the Loader will appear in a new window.
The
Stop
button in the Progress Window is used to instruct the Table Loader to abort processing. It may not stop immediately if it is currently running an external process such as the DBMS load utility. The Table Loader does not kill the utility; it waits for it to complete before stopping.

Batch

The Table Loader utility is called
loadit
. It is launched and managed in batch mode using the idsbatch utility.
The idsbatch is used to run user-defined jobs. The available jobs are defined in the User-Job-Definition section of the SDF.
For more information about user-defined jobs, refer to the
User-Job-Definition
and
User-Step-Definition
sections in the
DESIGN GUIDE
. For more information about the
idsbatch
utility, refer to the
Batch Utilities / idsbatch
section in this guide.

Starting Table Loader

To start the IDT load, along with the regular parameters, create an input text file (which has the instructions to perform the IDT load job) and pass it to the idsbatch utility. For example,
idsbatch -h%SSA_CSHOST% -id:\idt_load.txt -1d:\idt_load.log -2d:\idt_load.err
Instructions in the
idt_load.txt
are,
# Run user job # ------------ action=job-run job-name=user-job-loadit-IDT system-name=ssa rulebase-name=#SSA_RBNAME# work-directory=#SSAWORKDIR#
The job-name (
user-job-loadit-IDT
in the above example) should be defined in the User-Job-Definition section of the SDF. For example,
loader-definition *================ NAME=load-IDT JOB-LIST=job-loadit-IDT job-definition *============= NAME=job-loadit-IDT FILE=lf-srn-student IDT=IDT280 logical-file-definition *====================== NAME=lf-srn-student COMMENT="Read from SRN User Source Tables" PHYSICAL-FILE=IDT280 FORMAT=SQL user-job-definition *================== COMMENT="Load SRN_STUDENT IDT" NAME=user-job-loadit-IDT user-step-definition *=================== JOB=user-job-loadit-IDT NUMBER=0 NAME=run-loadit TYPE="Load ID Table" PARAMETERS=("Loader Definition",load-IDT)

Restarting from the beginning

If you wish to completely restart the load from the beginning, you must first Refresh the System. This can be done using the Console Client, or by defining a User-Job and running it with
idsbatch
. This will remove the IDT, IDXs, and any restart information left from the previous load attempt. After this, start the load again as documented above.

DBMS Mass Load Utility Name

The Table Loader will by default use the DBMS load utility that was specified at Install time and is available to it through the environment variable
SSASQLLDR
.
This specification can be overridden or redefined using
DATABASE-OPTIONS=IDTLOAD()
. Refer to the
System Definition
section of the
DESIGN GUIDE
for details.

0 COMMENTS

We’d like to hear from you!