Listdefs & Templates

David Birnie

Listdefs & Templates
Hi,

We are experimenting with listdefs & templates in our housekeeping jobs.

We are having problems with the image copy job locking out other jobs and
transactions.
Once the job starts, it holds locks on all tablespaces within the BSDP
database, not just the tablespace it is processing at the time.

Template & listdef statements look like :

TEMPLATE TMP1 UNIT CTAPE
DSN 'DBPA.C29902.DB2.&DB..&TS.(+1)'
DISP (NEW,CATLG,CATLG)
MODELDCB DB2.MODELDCB
GDGLIMIT (6)
STACK YES
RETPD 70
TEMPLATE TMP2 UNIT CTAPE
DSN 'DBPA.C29902.DRB.&DB..&TS.(+1)'
DISP (NEW,CATLG,CATLG)
MODELDCB DB2.MODELDCB
GDGLIMIT (6)
STACK YES
RETPD 70

LISTDEF CPY1 INCLUDE TABLESPACE BSDP.*

COPY LIST CPY1 COPYDDN (TMP1, TMP2)


We can get around the problem by coding multiple LISTDEF statements such
as :

LISTDEF CPY1 INCLUDE TABLESPACE BSDP.BSSP01
LISTDEF CPY2 INCLUDE TABLESPACE BSDP.BSSP02
LISTDEF CPY3 INCLUDE TABLESPACE BSDP.BSSP03 etc.

However, we would like to use the BSDP.* format if at all possible.

Is there something we are missing here, or is this just the way it is
intended to work ??

thanks
Dave.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Tony Provenzola

Re: Listdefs & Templates
(in response to David Birnie)
We ran into this, also. When you image copy multiple tablespaces with one copy statement, you're telling DB2 to establish one recovery point for all of the tablespaces, so it has to hold them all until they are all completed. I didn't like it when I ran into it, but it makes sense (just like a QUIESCE of multiple TSS).

You can either do a SHRLEVEL CHANGE or separate templates/copy statements (or exclude the large or high-use ones and do just them separately). We opted for separate copy statements, so we wouldn't lose the ability to UNLOAD FROMCOPY or RECOVER TOCOPY.

Tony Provenzola
Venturi Technology Partners, Consulting

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of David birnie
Sent: Monday, December 22, 2003 6:46 PM
To: [login to unmask email]
Subject: Listdefs & Templates



Hi,

We are experimenting with listdefs & templates in our housekeeping jobs.

We are having problems with the image copy job locking out other jobs and transactions.
Once the job starts, it holds locks on all tablespaces within the BSDP database, not just the tablespace it is processing at the time.

Template & listdef statements look like :

TEMPLATE TMP1 UNIT CTAPE
DSN 'DBPA.C29902.DB2.&DB..&TS.(+1)'
DISP (NEW,CATLG,CATLG)
MODELDCB DB2.MODELDCB
GDGLIMIT (6)
STACK YES
RETPD 70
TEMPLATE TMP2 UNIT CTAPE
DSN 'DBPA.C29902.DRB.&DB..&TS.(+1)'
DISP (NEW,CATLG,CATLG)
MODELDCB DB2.MODELDCB
GDGLIMIT (6)
STACK YES
RETPD 70

LISTDEF CPY1 INCLUDE TABLESPACE BSDP.*

COPY LIST CPY1 COPYDDN (TMP1, TMP2)


We can get around the problem by coding multiple LISTDEF statements such as :

LISTDEF CPY1 INCLUDE TABLESPACE BSDP.BSSP01
LISTDEF CPY2 INCLUDE TABLESPACE BSDP.BSSP02
LISTDEF CPY3 INCLUDE TABLESPACE BSDP.BSSP03 etc.


However, we would like to use the BSDP.* format if at all possible.

Is there something we are missing here, or is this just the way it is intended to work ??

thanks
Dave.
--------------------------------------------------------------------------------- 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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