How to view the status of DB2 Load utility on Windows/Unix

[Xie Qing]

Hi all,

Is there a tool or view to display the status of a Load utility job on
windows or Unix(say loading few million rows into a table)? I
understand in OS/390 there is a dis utility to show the status of the
utility. Is it also possible in UDB? I'm using UDB 8.1 on windows 2000.
Thanks for your time.

[Jan M. Nelken]

Xie Qing wrote:

Hi all,

Is there a tool or view to display the status of a Load utility job on
windows or Unix(say loading few million rows into a table)? I
understand in OS/390 there is a dis utility to show the status of the
utility. Is it also possible in UDB? I'm using UDB 8.1 on windows 2000.
Thanks for your time.

What will happen if you visit product documentation available at
http://publib.boulder.ibm.com/infoce...help/index.jsp and search for LOAD?
Will you spot LOAD QUERY command?

Jan M. Nelken

[Xie Qing]

Nelken,

Thanks for directing me to the correct place. Thanks a lot for your
help.

Jan M. Nelken wrote:

Xie Qing wrote:

Hi all,

Is there a tool or view to display the status of a Load utility job on windows or Unix(say loading few million rows into a table)? I
understand in OS/390 there is a dis utility to show the status of the utility. Is it also possible in UDB? I'm using UDB 8.1 on windows 2000.

Thanks for your time.

What will happen if you visit product documentation available at
http://publib.boulder.ibm.com/infoce...help/index.jsp and search

for LOAD? Will you spot LOAD QUERY command?

Jan M. Nelken

[peteh]

Jan M. Nelken wrote:

What will happen if you visit product documentation available at
http://publib.boulder.ibm.com/infoce...help/index.jsp and search for LOAD? Will you spot LOAD QUERY command?

Jan M. Nelken

Hi Jan;
I have been trying to use "LOAD QUERY table <tablename>" where
<tablename> is an existing table in current schema and am having some
trouble. Environment is DB2 AIX 8.1.5 Parallel Edition and I keep
getting one of two messages:
----------------------------------------------------------------------
SQL2306N The table or index <tablename> does not exist.
or
SQL6024E The table or index <tablename> is not defined on node "1".
----------------------------------------------------------------------

Do I need to connect to each node that is loading or the node on which
the table is defined or is something else going on? My hope was to use
the db2loadqry API and it seems that neither the API nor the command
will be of practical use if this is true... Any help appreciated.

Pete H

[Ian]

Hi Jan;
I have been trying to use "LOAD QUERY table <tablename>" where
<tablename> is an existing table in current schema and am having some
trouble. Environment is DB2 AIX 8.1.5 Parallel Edition and I keep
getting one of two messages:
No such thing as Parallel Edition any more. That was back in 96!
----------------------------------------------------------------------
SQL2306N The table or index <tablename> does not exist.
or
SQL6024E The table or index <tablename> is not defined on node "1".
----------------------------------------------------------------------

Do I need to connect to each node that is loading or the node on which
the table is defined or is something else going on? My hope was to use
the db2loadqry API and it seems that neither the API nor the command
will be of practical use if this is true... Any help appreciated.

A load happens independently on each partition in which the table is
defined, so to get a complete picture of the status you would need to
query each partition where the table is defined individually. This
restriction applies to the API call as well.

[peteh]

Thanks for the reply, Ian.

No such thing as Parallel Edition any more. That was back in 96!
Guess old habits die hard :-)
you would need to
query each partition where the table is defined individually. This
restriction applies to the API call as well.

Bummer - seems like it should be easier to monitor the status of a
load-in-progress. We do some big ones and it sometimes feels as though
we're "blind" till they complete (or fail).

Pete H

[Ian]

peteh wrote:

you would need to
query each partition where the table is defined individually. This
restriction applies to the API call as well.

Bummer - seems like it should be easier to monitor the status of a
load-in-progress. We do some big ones and it sometimes feels as though
we're "blind" till they complete (or fail).

Well, unless you have significant skew with in your data, you can just
query 1 partition and monitor its progress. Each partition should be
loading at roughly the same rate... If you know the total volume of
data that you're loading, and how many partitions it's loading on, it
shouldn't be too hard to monitor one partition and extrapolate.

Also, in 8.2, check out LIST UTILITIES.
Ian

[peteh]

> Also, in 8.2, check out LIST UTILITIES.

Many thanks Ian - this is just what the doctor ordered. We'll be
implementing 8.2 soon, so will wait for this feature.

Pete H