Operations Guide

10.2 HotFix 1
- 10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2
- 10.1 HotFix 1
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

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.

Table Loader

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal