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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Xie Qing - 22 Apr 2005 04:06 GMT

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.

Reply to this Message

Jan M. Nelken - 22 Apr 2005 05:25 GMT

> Hi all,
>
[quoted text clipped - 4 lines]
>
> Thanks for your time.

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

Jan M. Nelken

Reply to this Message

Xie Qing - 22 Apr 2005 06:52 GMT

Nelken,

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

> > Hi all,
> >
[quoted text clipped - 10 lines]
>
> Jan M. Nelken

Reply to this Message

peteh - 27 Apr 2005 18:32 GMT

> What will happen if you visit product documentation available at
> http://publib.boulder.ibm.com/infocenter/db2help/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

Reply to this Message

Ian - 27 Apr 2005 22:36 GMT

> 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.
[quoted text clipped - 6 lines]
> 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.

Reply to this Message

peteh - 28 Apr 2005 15:48 GMT

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

Reply to this Message

Ian - 29 Apr 2005 15:54 GMT

>>you would need to
>>query each partition where the table is defined individually. This
[quoted text clipped - 3 lines]
> 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

Reply to this Message

peteh - 29 Apr 2005 18:22 GMT

> 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

Reply to this Message