IBM DB2 Tools Worklist

Bill Brown

IBM DB2 Tools Worklist
Hi List,

One of my application programmers is wanting info on how to set up a
worklist with IBM's DB2 Tools. I searched the archives and only found a
couple of hits for "IBM DB2 Tools Worklist", so maybe they're not much
in vogue. I'm in the middle of a Z/OS upgrade and can't work on this at
the moment. I know NOTHING about worklists.

She needs to know how to create and execute a worklist that will let
her:

Stop a database
Unload tables
Drop a tablespace and it's associated indexes, views and grants.
Recreate that tablespace and tables with a number of columns removed
from two tables, along with their associated indexes, views and grants.
(This what she's having the most trouble with).
Load the tables
Do runstats

She needs to do this in both test and production, different
views/grants/indexes. She has done this with BMC tools and evidently it
was easy as sliding on greased ice. The IBM stuff requires more effort.

Any help appreciated. (Like how do you spell worklist?)

Thanks,
Bill Brown
Lead Sysprog
Texas Tech University



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Sevetson

Re: IBM DB2 Tools Worklist
(in response to Bill Brown)
If you're searching for hits, you probably will do better looking for the
manual for IBM's "DB2 Administration Tool" (the website for the tool is
here at"
http://www-306.ibm.com/software/data/db2imstools/db2tools/db2admin.html
)

The redbook on IBM's Change Management tools:
http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246420.pdf

An update on the tools:
http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65f/2cbc4b03a04662b688256acf00029c84?OpenDocument

And, finally, the user guide and reference manuals which can be referenced
through the index page at:
http://www-306.ibm.com/software/data/db2imstools/db2tools-library.html
where you will find the following two useful manuals.

1) The quick reference "manual" for the current version of these tools is
at
http://publib.boulder.ibm.com/epubs/pdf/adbrfc11.pdf

2) And the user guide:
http://publib.boulder.ibm.com/epubs/pdf/adbugd11.pdf



--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
230 Raritan Center Parkway, P5-105
Edison, NJ 08837
Phone: (732) 225-8086
Fax: (732) 225-8109
mailto:[login to unmask email]






"Brown, Bill" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/07/2004 12:18 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: [DB2-L] IBM DB2 Tools Worklist


Hi List,

One of my application programmers is wanting info on how to set up a
worklist with IBM's DB2 Tools. I searched the archives and only found a
couple of hits for "IBM DB2 Tools Worklist", so maybe they're not much in
vogue. I'm in the middle of a Z/OS upgrade and can't work on this at the
moment. I know NOTHING about worklists.

She needs to know how to create and execute a worklist that will let her:

Stop a database
Unload tables
Drop a tablespace and it's associated indexes, views and grants.
Recreate that tablespace and tables with a number of columns removed from
two tables, along with their associated indexes, views and grants. (This
what she's having the most trouble with).
Load the tables
Do runstats

She needs to do this in both test and production, different
views/grants/indexes. She has done this with BMC tools and evidently it
was easy as sliding on greased ice. The IBM stuff requires more effort.

Any help appreciated. (Like how do you spell worklist?)

Thanks,
Bill Brown
Lead Sysprog
Texas Tech University


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Colin Clayton

Re: IBM DB2 Tools Worklist
(in response to Philip Sevetson)
Hi Bill,

You could look at IBM's "DB2 Information Management Software Information
Center " at http://publib.boulder.ibm.com/infocenter/dzichelp/index.jsp
< http://publib.boulder.ibm.com/infocenter/dzichelp/index.jsp > - then click
on the IBM DB2 Tools heading.
I believe the term you are looking for is a 'Work Statement List'.

I'd be interested to hear how it frictionless it is in comparison with any
of the ISV products.

Colin

(No vendor plug intended. My opinion only)





_____

From: Brown, Bill [mailto:[login to unmask email]
Sent: 07 December 2004 17:18
To: [login to unmask email]
Subject: IBM DB2 Tools Worklist


Hi List,

One of my application programmers is wanting info on how to set up a
worklist with IBM's DB2 Tools. I searched the archives and only found a
couple of hits for "IBM DB2 Tools Worklist", so maybe they're not much in
vogue. I'm in the middle of a Z/OS upgrade and can't work on this at the
moment. I know NOTHING about worklists.

She needs to know how to create and execute a worklist that will let her:

Stop a database
Unload tables
Drop a tablespace and it's associated indexes, views and grants.
Recreate that tablespace and tables with a number of columns removed from
two tables, along with their associated indexes, views and grants. (This
what she's having the most trouble with).
Load the tables
Do runstats

She needs to do this in both test and production, different
views/grants/indexes. She has done this with BMC tools and evidently it was
easy as sliding on greased ice. The IBM stuff requires more effort.

Any help appreciated. (Like how do you spell worklist?)

Thanks,
Bill Brown
Lead Sysprog
Texas Tech University


----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

jwkwan2000

Re: IBM DB2 Tools Worklist
(in response to Colin Clayton)
MessageBill,

It sounds like she needs to do an alter to 2 tables in the same tablespace. During the alter operation, she needs to select the option to use WORKLIST so jobs will be generated to create WORKLIST. The alter step will perform unload, drop tables, redefine tables with new column definitions, reload data and runstats.
If she wants to stop tablespace, a separate stop tablespace step can be added to the worklist.
Contact me if you/she needs more details.

James Kwan

----- Original Message -----
From: Brown, Bill
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Tuesday, December 07, 2004 11:18 AM
Subject: IBM DB2 Tools Worklist


Hi List,

One of my application programmers is wanting info on how to set up a worklist with IBM's DB2 Tools. I searched the archives and only found a couple of hits for "IBM DB2 Tools Worklist", so maybe they're not much in vogue. I'm in the middle of a Z/OS upgrade and can't work on this at the moment. I know NOTHING about worklists.

She needs to know how to create and execute a worklist that will let her:

Stop a database
Unload tables
Drop a tablespace and it's associated indexes, views and grants.
Recreate that tablespace and tables with a number of columns removed from two tables, along with their associated indexes, views and grants. (This what she's having the most trouble with).
Load the tables
Do runstats

She needs to do this in both test and production, different views/grants/indexes. She has done this with BMC tools and evidently it was easy as sliding on greased ice. The IBM stuff requires more effort.

Any help appreciated. (Like how do you spell worklist?)

Thanks,
Bill Brown
Lead Sysprog
Texas Tech University


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm