{Blank Subject Dec 09, 2010}

Andy Pesce

{Blank Subject Dec 09, 2010}
SET NODIGEST

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of DB2-L automatic digest system
Sent: Thursday, December 09, 2010 12:00 AM
To: [login to unmask email]
Subject: DB2-L Digest - 8 Dec 2010 to 9 Dec 2010 (#2010-332)

There are 32 messages totaling 4822 lines in this issue.

Topics of the day:

1. EDM DBD Space (3)
2. John Campbell's DB2 for z/OS presentations
3. Baltimore / Washington DB2 Users' Meeting 12/8/2010 (3)
4. XML challenge (5)
5. Betr: [DB2-L] XML challenge (4)
6. [SPAM] Betr: [DB2-L] XML challenge
7. DB2 for z/OS - error with UNLOAD utility (10)
8. CICS TS 2.3
9. Off Topic ERwin Question
10. Online reorg of large tablespace with many indexes (2)
11. [SPAM] Online reorg of large tablespace with many indexes

----------------------------------------------------------------------

Date: Wed, 8 Dec 2010 10:01:48 +0100
From: Roy Boxwell <[login to unmask email]>
Subject: Re: EDM DBD Space

dont forget to REORG it as this does the actuall resize (I think...)

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert



"Sevetson, Phil" <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
07.12.2010 18:39
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] EDM DBD Space






Anil,
The cause of your problem _may_ be DBD size for one or more databases.

DBD size increases whenever a table is created, and does not decrease when
the table is dropped (except as noted below). For example, if you have a
tablespace in your environment which is the target of a lot of QMF SAVE
DATA statements, it will grow until it is large enough that it can no
longer be loaded.

You can find the size of a DBD by executing the DB2 command:
-DISPLAY DATABASE(dbname)
The response to this command will indicate a DBD size in bytes.

The way to reduce this space, eliminating DBD entries for tables which no
longer exist (if that is the cause of your problem), is to run the DB2
MODIFY RECOVERY utility, with the statement:

MODIFY RECOVERY TABLESPACE database.tablespace DELETE AGE(some small
integer value, a number of days for which you need to retain image copies)

After the MODIFY RECOVERY, a –DISPLAY DATABASE should reveal a smaller
DBD. If this database continues to have problems, you might have to
DELETE AGE to a smaller AGE value.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil
Sent: Tuesday, December 07, 2010 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] EDM DBD Space

Hi All,

I noticed that lately we get a -904 (resource unavailable) because of EDM
DBD Space not available.. Before I ask our systems guy to increase the DBD
size I need to determine the reason why we get the -904. Any idea how
would I investigate the reason for the -904 (this is on DB2 V9 for z/os).

Thanks.

Anil

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cg

------------------------------

Date: Wed, 8 Dec 2010 08:32:10 -0500
From: DB2usa !!! <[login to unmask email]>
Subject: John Campbell's DB2 for z/OS presentations


Hi DB2 user,

Here is a non-profit Blog about DB2 for z/OS (IBM mainframes):
http://db2usa.blogspot.com

Last update on Monday, November 29th 2010

Here are several John Campbell's DB2 for z/OS presentations available on IBM and Tridex websites:

- Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace
by John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 1
by John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 2
by John Campbell

- DB2 10 for z/OS Technical Overview
by John Campbell

- DB2 10 for z/OS Performance Preview
by John Campbell

More information

- Best Practices for DB2 Software Maintenance
by John Campbell and Michael Dewert

- DB2 9 for z/OS: Migration and Experiences
by Maja Kovac


Regards,
DB2usa.
http://db2usa.blogspot.com







.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 10:08:51 -0500
From: "Sevetson, Phil" <[login to unmask email]>
Subject: Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010

Henry,

All four of those presentations look chock-full of chewy goodness! Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them. Would you let them know about our interest, please?

I believe the IDUG website has a way to host such things; I'll look around and see what I can find.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
Sent: Tuesday, December 07, 2010 10:49 AM
To: [login to unmask email]
Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010

BWDB2UG Quarterly Meeting

!!!! For those Registered for the meeting, both z/OS and LUW,
 Please see the website for session handouts which may be downloaded for your use during the meeting !!!!

www.bwdb2ug.org

To pre-register, please mail the appropriate fee with attendee's and employer's name to:

THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
P.O. BOX 18554
BWI AIRPORT, MARYLAND 21240

All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:

Visit our website, www.bwdb2ug.org, for more information.

When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40

At-the-door for non-members: $50
Meeting Schedule:
8:30 – 9:00 Registration

9:00 – 10:15 DB2 and Work Load Management (WLM)
Mark Rader, IBM

Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.

10:15 – 10:30 Coffee Break

10:30 – 11:45 Enhanced Monitoring support in DB2 v10
Mark Rader, IBM

DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.

11:45 – 12:45 Lunch

12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
John Iczkovits, IBM

Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.

2:00 – 2:15 Break

2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
Paul Walters

Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.

Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.

John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.

Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 10:10:56 -0500
From: "Sevetson, Phil" <[login to unmask email]>
Subject: Re: EDM DBD Space

Roy,

As of several releases ago, the last time I confronted this problem, the MODIFY RECOVERY was all that was needed. Again, this assumes that DBD size due to creates and drops is Anil's problem, of course.

--Phil Sevetson

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Boxwell
Sent: Wednesday, December 08, 2010 4:02 AM
To: [login to unmask email]
Subject: Re: [DB2-L] EDM DBD Space


dont forget to REORG it as this does the actuall resize (I think...)

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert

"Sevetson, Phil" <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>

07.12.2010 18:39
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An

[login to unmask email]

Kopie



Thema

Re: [DB2-L] EDM DBD Space










Anil,
The cause of your problem _may_ be DBD size for one or more databases.

DBD size increases whenever a table is created, and does not decrease when the table is dropped (except as noted below). For example, if you have a tablespace in your environment which is the target of a lot of QMF SAVE DATA statements, it will grow until it is large enough that it can no longer be loaded.

You can find the size of a DBD by executing the DB2 command:
-DISPLAY DATABASE(dbname)
The response to this command will indicate a DBD size in bytes.

The way to reduce this space, eliminating DBD entries for tables which no longer exist (if that is the cause of your problem), is to run the DB2 MODIFY RECOVERY utility, with the statement:

MODIFY RECOVERY TABLESPACE database.tablespace DELETE AGE(some small integer value, a number of days for which you need to retain image copies)

After the MODIFY RECOVERY, a -DISPLAY DATABASE should reveal a smaller DBD. If this database continues to have problems, you might have to DELETE AGE to a smaller AGE value.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil
Sent: Tuesday, December 07, 2010 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] EDM DBD Space

Hi All,

I noticed that lately we get a -904 (resource unavailable) because of EDM DBD Space not available.. Before I ask our systems guy to increase the DBD size I need to determine the reason why we get the -904. Any idea how would I investigate the reason for the -904 (this is on DB2 V9 for z/os).

Thanks.

Anil

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv



________________________________

< http://www.idug.org/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >



________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 07:18:44 -0800
From: Dan Luksetich <[login to unmask email]>
Subject: XML challenge

Folks,
I have some XML in a string stored in a varchar field of 16,000 bytes
EBCDIC. I am interested in an SQL statement that will convert the string
into an XML data type such that various XML functions can then be applied
to the XML result. Anyone done this with success? I'm currently playing
with the XMLCAST and XMLSERIALIZE functions. I'm not getting the expected
results.

Thanks,
Dan Luksetich

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 16:26:20 +0100
From: Marcel Harleman <[login to unmask email]>
Subject: Betr: [DB2-L] XML challenge



Maybe

SELECT XMLSERIALIZE (
XMLDOCUMENT(
XMLCONCAT (
XMLELEMENT ( NAME "blabla", colname )
)
)
AS CLOB
INCLUDING XMLDECLARATION
)
FROM creator.tablename


does work?


Regards,

Marcel.


------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 16:30:52 +0100
From: Marcel Harleman <[login to unmask email]>
Subject: Betr: [DB2-L] XML challenge



Ah, so quick with enter -:)

It should be:

SELECT XMLDOCUMENT(
XMLCONCAT (
XMLELEMENT ( NAME "blabla", colname )
)
)
FROM creator.tablename


Regards, Marcel.


------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 09:38:20 -0600
From: Dave Churn <[login to unmask email]>
Subject: Re: Betr: [DB2-L] XML challenge

Marcel,

It returns SQLCODE=-170

DSNT408I SQLCODE = -170, ERROR: THE NUMBER OF ARGUMENTS SPECIFIED FOR
XMLCONCAT IS INVALID
DSNT418I SQLSTATE = 42605 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOBFF SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 170 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000000AA' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

Do you need the XMLCONCAT?

--
David Churn
Database Architect, DST Systems, Inc.

On Wed, Dec 8, 2010 at 9:26 AM, Marcel Harleman <
[login to unmask email]> wrote:

> Maybe
>
> SELECT XMLSERIALIZE (
> XMLDOCUMENT(
> XMLCONCAT (
> XMLELEMENT ( NAME "blabla", colname )
> )
> )
> AS CLOB
> INCLUDING XMLDECLARATION
> )
> FROM creator.tablename
>
>
> does work?
>
>
> Regards,
>
> Marcel.
>
> ------------------------------------------------------------------------
> De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
> vertrouwelijke informatie met de burger of voor de bekendmaking
> van beslissingen. De Belastingdienst hanteert conventies voor het
> gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.
>
>
>
> ------------------------------
>
> [image: Independent, not-for-profit, User Run - the IDUG difference! ] < http://www.idug.org >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 10:30:00 -0500
From: "B. L. \"Tink\" Tysor" <[login to unmask email]>
Subject: Re: XML challenge

Hi Dan,

I spent a lot of time trying to debug XML stuff, and found out that I had
not been careful enough with the NAMESPACE decelerations.
Just a shot in the dark,

Tink
On Wed, Dec 8, 2010 at 10:18 AM, Dan Luksetich <[login to unmask email]> wrote:

> Folks,
> I have some XML in a string stored in a varchar field of 16,000 bytes
> EBCDIC. I am interested in an SQL statement that will convert the string
> into an XML data type such that various XML functions can then be applied
> to the XML result. Anyone done this with success? I'm currently playing
> with the XMLCAST and XMLSERIALIZE functions. I'm not getting the expected
> results.
>
> Thanks,
> Dan Luksetich
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA < http://idug.org/NA > *
> * If you are going to attend only one conference this year, this is it!
> *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>



--
B.L. "Tink" Tysor
Bayard Lee Tysor, Inc.
[login to unmask email]
401-965-2688

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 07:44:09 -0800
From: Ed Long <[login to unmask email]>
Subject: Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010

I agree these presentations look terrific.

The New England DB2 User's Group has it's own website. NEDB2UG.ORG. We would be delighted to host these documents.

All of our presentations from the last 5 years or so are also available at our website.

Just send the stuff to me and I can, to quote J.L. Picard, make it so.

Edward Long

--- On Wed, 12/8/10, Sevetson, Phil <[login to unmask email]> wrote:


From: Sevetson, Phil <[login to unmask email]>
Subject: Re: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010
To: [login to unmask email]
Date: Wednesday, December 8, 2010, 10:08 AM


Henry,

All four of those presentations look chock-full of chewy goodness! Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them. Would you let them know about our interest, please?

I believe the IDUG website has a way to host such things; I'll look around and see what I can find.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
Sent: Tuesday, December 07, 2010 10:49 AM
To: [login to unmask email]
Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010

BWDB2UG Quarterly Meeting

!!!! For those Registered for the meeting, both z/OS and LUW,
 Please see the website for session handouts which may be downloaded for your use during the meeting !!!!

www.bwdb2ug.org

To pre-register, please mail the appropriate fee with attendee's and employer's name to:

THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
P.O. BOX 18554
BWI AIRPORT, MARYLAND 21240

All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:

Visit our website, www.bwdb2ug.org, for more information.

When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40

At-the-door for non-members: $50
Meeting Schedule:
8:30 – 9:00 Registration

9:00 – 10:15 DB2 and Work Load Management (WLM)
Mark Rader, IBM

Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.

10:15 – 10:30 Coffee Break

10:30 – 11:45 Enhanced Monitoring support in DB2 v10
Mark Rader, IBM

DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.

11:45 – 12:45 Lunch

12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
John Iczkovits, IBM

Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.

2:00 – 2:15 Break

2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
Paul Walters

Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.

Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.

John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.

Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 07:44:26 -0800
From: Dan Luksetich <[login to unmask email]>
Subject: Re: [SPAM] Betr: [DB2-L] XML challenge

Specifically the problem I am having, both with my attempts and your
suggestion, is that my tags are getting modified. For example...

<name>Bob</name>

becomes...

<name%gt;Bob</name>

Look for a way to preserve the tag as is.

Thanks,
Dan


On Wed, 8 Dec 2010 16:26:20 +0100, Marcel Harleman
<[login to unmask email]> wrote:
> Maybe
>
> SELECT XMLSERIALIZE (
> XMLDOCUMENT(
> XMLCONCAT (
> XMLELEMENT ( NAME "blabla", colname )
> )
> )
> AS CLOB
> INCLUDING XMLDECLARATION
> )
> FROM creator.tablename
>
>
> does work?
>
>
> Regards,
>
> Marcel.
>
>
> ------------------------------------------------------------------------
> De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
> vertrouwelijke informatie met de burger of voor de bekendmaking
> van beslissingen. De Belastingdienst hanteert conventies voor het
> gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is
it!
> *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is
> the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 09:55:04 -0600
From: Willie Favero <[login to unmask email]>
Subject: Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010

SlideShare.com is a great way to share presentations.

Willie

On 12/8/2010 9:08 AM, Sevetson, Phil wrote:
> Henry,
>
> All four of those presentations look chock-full of chewy goodness! Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them. Would you let them know about our interest, please?
>
> I believe the IDUG website has a way to host such things; I'll look around and see what I can find.
>
> --Phil Sevetson
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
> Sent: Tuesday, December 07, 2010 10:49 AM
> To: [login to unmask email]
> Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010
>
> BWDB2UG Quarterly Meeting
>
> !!!! For those Registered for the meeting, both z/OS and LUW,
>  Please see the website for session handouts which may be downloaded for your use during the meeting !!!!
>
> www.bwdb2ug.org
>
> To pre-register, please mail the appropriate fee with attendee's and employer's name to:
>
> THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
> P.O. BOX 18554
> BWI AIRPORT, MARYLAND 21240
>
> All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:
>
> Visit our website, www.bwdb2ug.org, for more information.
>
> When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
> Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900
>
> Meeting Fees:
> Pre-registered members: $30
> Pre-registered non-members: $40
> At-the-door for members: $40
>
> At-the-door for non-members: $50
> Meeting Schedule:
> 8:30 – 9:00 Registration
>
> 9:00 – 10:15 DB2 and Work Load Management (WLM)
> Mark Rader, IBM
>
> Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.
>
> 10:15 – 10:30 Coffee Break
>
> 10:30 – 11:45 Enhanced Monitoring support in DB2 v10
> Mark Rader, IBM
>
> DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.
>
> 11:45 – 12:45 Lunch
>
> 12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
> John Iczkovits, IBM
>
> Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.
>
> 2:00 – 2:15 Break
>
> 2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
> Paul Walters
>
> Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.
>
> Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.
>
> John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.
>
> Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2 information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is it! *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 08:17:04 -0800
From: Dan Luksetich <[login to unmask email]>
Subject: Re: Betr: [DB2-L] XML challenge

got it! XMLPARSE did the job!

Thanks for the advice.

Dan


On Wed, 8 Dec 2010 16:26:20 +0100, Marcel Harleman
<[login to unmask email]> wrote:
> Maybe
>
> SELECT XMLSERIALIZE (
> XMLDOCUMENT(
> XMLCONCAT (
> XMLELEMENT ( NAME "blabla", colname )
> )
> )
> AS CLOB
> INCLUDING XMLDECLARATION
> )
> FROM creator.tablename
>
>
> does work?
>
>
> Regards,
>
> Marcel.
>
>
> ------------------------------------------------------------------------
> De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
> vertrouwelijke informatie met de burger of voor de bekendmaking
> van beslissingen. De Belastingdienst hanteert conventies voor het
> gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is
it!
> *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is
> the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 16:30:55 +0000
From: Jim McAlpine <[login to unmask email]>
Subject: DB2 for z/OS - error with UNLOAD utility

I'm getting the following -

DSNU000I 342 17:21:56.24 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID =
UNLOADU
DSNU1044I 342 17:21:56.26 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 342 17:21:56.27 DSNUGUTC - LISTDEF UNLDLIST INCLUDE TABLE
Z30D.T*
DSNU1035I 342 17:21:56.27 DSNUILDR - LISTDEF STATEMENT PROCESSED
SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - TEMPLATE UNLDDS DSN
Z30D.UNLOAD.DATA.&TS. DISP(NEW, CATLG, CATLG) SPACE(
750, 750) TRK UNIT 3390 VOLUMES(VPWRAZ)
DSNU1035I 342 17:21:56.27 DSNUJTDR - TEMPLATE STATEMENT PROCESSED
SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - TEMPLATE PUNCHDS DSN
Z30D.UNLOAD.PARM.&TS. DISP(NEW, CATLG, CATLG) SPACE(1,
1) TRK UNIT 3390 VOLUMES(VPWRAZ)
DSNU1035I 342 17:21:56.27 DSNUJTDR - TEMPLATE STATEMENT PROCESSED
SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - UNLOAD LIST UNLDLIST PUNCHDDN
PUNCHDS UNLDDN UNLDDS
DSNU1033I 342 17:22:06.13 DSNUGULM - PROCESSING LIST ITEM: TABLESPACE
Z30DDA01.SAACMPY
DSNU1221I 342 17:22:06.16 DSNUUNLD - UNLDDN IS NOT SPECIFIED OR SPECIFIED
TEMPLATE UNLDDS IS INVALID FOR MULTIPLE
TABLE SPACES
DSNU012I 342 17:22:06.17 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST
RETURN CODE=8
and I can't see an error with the templates.

Also, if I add PREVIEW to the job it runs to completion and the dataset
names are correctly expanded like so -

DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDZ01.SZZAUDIT
DSNUGPVV - TEMPLATE UNLDDS DSN=Z30D.UNLOAD.DATA.SZZAUDIT
DSNUGPVV - TEMPLATE PUNCHDS DSN=Z30D.UNLOAD.PARM.SZZAUDIT
DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDZ01.SZZCNTRL
DSNUGPVV - TEMPLATE UNLDDS DSN=Z30D.UNLOAD.DATA.SZZCNTRL
DSNUGPVV - TEMPLATE PUNCHDS DSN=Z30D.UNLOAD.PARM.SZZCNTRL
DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDZ01.SZZPLAN
DSNUGPVV - TEMPLATE UNLDDS DSN=Z30D.UNLOAD.DATA.SZZPLAN
DSNUGPVV - TEMPLATE PUNCHDS DSN=Z30D.UNLOAD.PARM.SZZPLAN
DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDZ01.SZZXRST
DSNUGPVV - TEMPLATE UNLDDS DSN=Z30D.UNLOAD.DATA.SZZXRST
DSNUGPVV - TEMPLATE PUNCHDS DSN=Z30D.UNLOAD.PARM.SZZXRST
DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
Any ideas ?

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 10:33:48 -0500
From: Mike Lefebvre <[login to unmask email]>
Subject: CICS TS 2.3

Has anyone tested DB2 V10 with CICS TS 2.3?

Tks.
Mike Lefebvre

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 11:41:16 -0500
From: "Doyle, Mark M2" <[login to unmask email]>
Subject: Re: DB2 for z/OS - error with UNLOAD utility

My guess - and is just a guess - 2 tables each having the same TS name (in different databases).

Mark



This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and
any attachments are believed to be free of any virus or other
defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to
ensure that it is virus free and no responsibility is accepted by
JPMorgan Chase & Co., its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use.
If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

------------------------------

Date: Wed, 8 Dec 2010 10:41:56 -0600
From: "Bell, Raymond" <[login to unmask email]>
Subject: Re: DB2 for z/OS - error with UNLOAD utility

Jim,

Just guessing but is the tablespace name unique for your Listdef? You're selecting objects by table name but the Template is using tablespace name - there may be TBs in TSs of the same name, but in different DBs. If that's the case, maybe add &DB to your Template def.

Cheers,


Raymond
PS. OMG, giving suggestions on how to run IBM utilities. Hope no one's watching...

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: 08 December 2010 16:31
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS - error with UNLOAD utility

I'm getting the following -

DSNU000I 342 17:21:56.24 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = UNLOADU
DSNU1044I 342 17:21:56.26 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 342 17:21:56.27 DSNUGUTC - LISTDEF UNLDLIST INCLUDE TABLE Z30D.T*
DSNU1035I 342 17:21:56.27 DSNUILDR - LISTDEF STATEMENT PROCESSED SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - TEMPLATE UNLDDS DSN Z30D.UNLOAD.DATA.&TS. DISP(NEW, CATLG, CATLG) SPACE(
750, 750) TRK UNIT 3390 VOLUMES(VPWRAZ)
DSNU1035I 342 17:21:56.27 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - TEMPLATE PUNCHDS DSN Z30D.UNLOAD.PARM.&TS. DISP(NEW, CATLG, CATLG) SPACE(1,
1) TRK UNIT 3390 VOLUMES(VPWRAZ)
DSNU1035I 342 17:21:56.27 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - UNLOAD LIST UNLDLIST PUNCHDDN PUNCHDS UNLDDN UNLDDS
DSNU1033I 342 17:22:06.13 DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDA01.SAACMPY
DSNU1221I 342 17:22:06.16 DSNUUNLD - UNLDDN IS NOT SPECIFIED OR SPECIFIED TEMPLATE UNLDDS IS INVALID FOR MULTIPLE
TABLE SP

Andy Pesce

(in response to Andy Pesce)
SET DB2-L NODIGEST

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of DB2-L automatic digest system
Sent: Thursday, December 09, 2010 12:00 AM
To: [login to unmask email]
Subject: DB2-L Digest - 8 Dec 2010 to 9 Dec 2010 (#2010-332)

There are 32 messages totaling 4822 lines in this issue.

Topics of the day:

1. EDM DBD Space (3)
2. John Campbell's DB2 for z/OS presentations
3. Baltimore / Washington DB2 Users' Meeting 12/8/2010 (3)
4. XML challenge (5)
5. Betr: [DB2-L] XML challenge (4)
6. [SPAM] Betr: [DB2-L] XML challenge
7. DB2 for z/OS - error with UNLOAD utility (10)
8. CICS TS 2.3
9. Off Topic ERwin Question
10. Online reorg of large tablespace with many indexes (2)
11. [SPAM] Online reorg of large tablespace with many indexes

----------------------------------------------------------------------

Date: Wed, 8 Dec 2010 10:01:48 +0100
From: Roy Boxwell <[login to unmask email]>
Subject: Re: EDM DBD Space

dont forget to REORG it as this does the actuall resize (I think...)

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert



"Sevetson, Phil" <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
07.12.2010 18:39
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] EDM DBD Space






Anil,
The cause of your problem _may_ be DBD size for one or more databases.

DBD size increases whenever a table is created, and does not decrease when
the table is dropped (except as noted below). For example, if you have a
tablespace in your environment which is the target of a lot of QMF SAVE
DATA statements, it will grow until it is large enough that it can no
longer be loaded.

You can find the size of a DBD by executing the DB2 command:
-DISPLAY DATABASE(dbname)
The response to this command will indicate a DBD size in bytes.

The way to reduce this space, eliminating DBD entries for tables which no
longer exist (if that is the cause of your problem), is to run the DB2
MODIFY RECOVERY utility, with the statement:

MODIFY RECOVERY TABLESPACE database.tablespace DELETE AGE(some small
integer value, a number of days for which you need to retain image copies)

After the MODIFY RECOVERY, a –DISPLAY DATABASE should reveal a smaller
DBD. If this database continues to have problems, you might have to
DELETE AGE to a smaller AGE value.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil
Sent: Tuesday, December 07, 2010 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] EDM DBD Space

Hi All,

I noticed that lately we get a -904 (resource unavailable) because of EDM
DBD Space not available.. Before I ask our systems guy to increase the DBD
size I need to determine the reason why we get the -904. Any idea how
would I investigate the reason for the -904 (this is on DB2 V9 for z/os).

Thanks.

Anil

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cg

------------------------------

Date: Wed, 8 Dec 2010 08:32:10 -0500
From: DB2usa !!! <[login to unmask email]>
Subject: John Campbell's DB2 for z/OS presentations


Hi DB2 user,

Here is a non-profit Blog about DB2 for z/OS (IBM mainframes):
http://db2usa.blogspot.com

Last update on Monday, November 29th 2010

Here are several John Campbell's DB2 for z/OS presentations available on IBM and Tridex websites:

- Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace
by John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 1
by John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 2
by John Campbell

- DB2 10 for z/OS Technical Overview
by John Campbell

- DB2 10 for z/OS Performance Preview
by John Campbell

More information

- Best Practices for DB2 Software Maintenance
by John Campbell and Michael Dewert

- DB2 9 for z/OS: Migration and Experiences
by Maja Kovac


Regards,
DB2usa.
http://db2usa.blogspot.com







.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 10:08:51 -0500
From: "Sevetson, Phil" <[login to unmask email]>
Subject: Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010

Henry,

All four of those presentations look chock-full of chewy goodness! Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them. Would you let them know about our interest, please?

I believe the IDUG website has a way to host such things; I'll look around and see what I can find.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
Sent: Tuesday, December 07, 2010 10:49 AM
To: [login to unmask email]
Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010

BWDB2UG Quarterly Meeting

!!!! For those Registered for the meeting, both z/OS and LUW,
 Please see the website for session handouts which may be downloaded for your use during the meeting !!!!

www.bwdb2ug.org

To pre-register, please mail the appropriate fee with attendee's and employer's name to:

THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
P.O. BOX 18554
BWI AIRPORT, MARYLAND 21240

All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:

Visit our website, www.bwdb2ug.org, for more information.

When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40

At-the-door for non-members: $50
Meeting Schedule:
8:30 – 9:00 Registration

9:00 – 10:15 DB2 and Work Load Management (WLM)
Mark Rader, IBM

Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.

10:15 – 10:30 Coffee Break

10:30 – 11:45 Enhanced Monitoring support in DB2 v10
Mark Rader, IBM

DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.

11:45 – 12:45 Lunch

12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
John Iczkovits, IBM

Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.

2:00 – 2:15 Break

2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
Paul Walters

Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.

Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.

John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.

Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 10:10:56 -0500
From: "Sevetson, Phil" <[login to unmask email]>
Subject: Re: EDM DBD Space

Roy,

As of several releases ago, the last time I confronted this problem, the MODIFY RECOVERY was all that was needed. Again, this assumes that DBD size due to creates and drops is Anil's problem, of course.

--Phil Sevetson

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Boxwell
Sent: Wednesday, December 08, 2010 4:02 AM
To: [login to unmask email]
Subject: Re: [DB2-L] EDM DBD Space


dont forget to REORG it as this does the actuall resize (I think...)

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert

"Sevetson, Phil" <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>

07.12.2010 18:39
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An

[login to unmask email]

Kopie



Thema

Re: [DB2-L] EDM DBD Space










Anil,
The cause of your problem _may_ be DBD size for one or more databases.

DBD size increases whenever a table is created, and does not decrease when the table is dropped (except as noted below). For example, if you have a tablespace in your environment which is the target of a lot of QMF SAVE DATA statements, it will grow until it is large enough that it can no longer be loaded.

You can find the size of a DBD by executing the DB2 command:
-DISPLAY DATABASE(dbname)
The response to this command will indicate a DBD size in bytes.

The way to reduce this space, eliminating DBD entries for tables which no longer exist (if that is the cause of your problem), is to run the DB2 MODIFY RECOVERY utility, with the statement:

MODIFY RECOVERY TABLESPACE database.tablespace DELETE AGE(some small integer value, a number of days for which you need to retain image copies)

After the MODIFY RECOVERY, a -DISPLAY DATABASE should reveal a smaller DBD. If this database continues to have problems, you might have to DELETE AGE to a smaller AGE value.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil
Sent: Tuesday, December 07, 2010 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] EDM DBD Space

Hi All,

I noticed that lately we get a -904 (resource unavailable) because of EDM DBD Space not available.. Before I ask our systems guy to increase the DBD size I need to determine the reason why we get the -904. Any idea how would I investigate the reason for the -904 (this is on DB2 V9 for z/os).

Thanks.

Anil

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv



________________________________

< http://www.idug.org/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >



________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 07:18:44 -0800
From: Dan Luksetich <[login to unmask email]>
Subject: XML challenge

Folks,
I have some XML in a string stored in a varchar field of 16,000 bytes
EBCDIC. I am interested in an SQL statement that will convert the string
into an XML data type such that various XML functions can then be applied
to the XML result. Anyone done this with success? I'm currently playing
with the XMLCAST and XMLSERIALIZE functions. I'm not getting the expected
results.

Thanks,
Dan Luksetich

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 16:26:20 +0100
From: Marcel Harleman <[login to unmask email]>
Subject: Betr: [DB2-L] XML challenge



Maybe

SELECT XMLSERIALIZE (
XMLDOCUMENT(
XMLCONCAT (
XMLELEMENT ( NAME "blabla", colname )
)
)
AS CLOB
INCLUDING XMLDECLARATION
)
FROM creator.tablename


does work?


Regards,

Marcel.


------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 16:30:52 +0100
From: Marcel Harleman <[login to unmask email]>
Subject: Betr: [DB2-L] XML challenge



Ah, so quick with enter -:)

It should be:

SELECT XMLDOCUMENT(
XMLCONCAT (
XMLELEMENT ( NAME "blabla", colname )
)
)
FROM creator.tablename


Regards, Marcel.


------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 09:38:20 -0600
From: Dave Churn <[login to unmask email]>
Subject: Re: Betr: [DB2-L] XML challenge

Marcel,

It returns SQLCODE=-170

DSNT408I SQLCODE = -170, ERROR: THE NUMBER OF ARGUMENTS SPECIFIED FOR
XMLCONCAT IS INVALID
DSNT418I SQLSTATE = 42605 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOBFF SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 170 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000000AA' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

Do you need the XMLCONCAT?

--
David Churn
Database Architect, DST Systems, Inc.

On Wed, Dec 8, 2010 at 9:26 AM, Marcel Harleman <
[login to unmask email]> wrote:

> Maybe
>
> SELECT XMLSERIALIZE (
> XMLDOCUMENT(
> XMLCONCAT (
> XMLELEMENT ( NAME "blabla", colname )
> )
> )
> AS CLOB
> INCLUDING XMLDECLARATION
> )
> FROM creator.tablename
>
>
> does work?
>
>
> Regards,
>
> Marcel.
>
> ------------------------------------------------------------------------
> De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
> vertrouwelijke informatie met de burger of voor de bekendmaking
> van beslissingen. De Belastingdienst hanteert conventies voor het
> gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.
>
>
>
> ------------------------------
>
> [image: Independent, not-for-profit, User Run - the IDUG difference! ] < http://www.idug.org >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 10:30:00 -0500
From: "B. L. \"Tink\" Tysor" <[login to unmask email]>
Subject: Re: XML challenge

Hi Dan,

I spent a lot of time trying to debug XML stuff, and found out that I had
not been careful enough with the NAMESPACE decelerations.
Just a shot in the dark,

Tink
On Wed, Dec 8, 2010 at 10:18 AM, Dan Luksetich <[login to unmask email]> wrote:

> Folks,
> I have some XML in a string stored in a varchar field of 16,000 bytes
> EBCDIC. I am interested in an SQL statement that will convert the string
> into an XML data type such that various XML functions can then be applied
> to the XML result. Anyone done this with success? I'm currently playing
> with the XMLCAST and XMLSERIALIZE functions. I'm not getting the expected
> results.
>
> Thanks,
> Dan Luksetich
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA < http://idug.org/NA > *
> * If you are going to attend only one conference this year, this is it!
> *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>



--
B.L. "Tink" Tysor
Bayard Lee Tysor, Inc.
[login to unmask email]
401-965-2688

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 07:44:09 -0800
From: Ed Long <[login to unmask email]>
Subject: Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010

I agree these presentations look terrific.

The New England DB2 User's Group has it's own website. NEDB2UG.ORG. We would be delighted to host these documents.

All of our presentations from the last 5 years or so are also available at our website.

Just send the stuff to me and I can, to quote J.L. Picard, make it so.

Edward Long

--- On Wed, 12/8/10, Sevetson, Phil <[login to unmask email]> wrote:


From: Sevetson, Phil <[login to unmask email]>
Subject: Re: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010
To: [login to unmask email]
Date: Wednesday, December 8, 2010, 10:08 AM


Henry,

All four of those presentations look chock-full of chewy goodness! Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them. Would you let them know about our interest, please?

I believe the IDUG website has a way to host such things; I'll look around and see what I can find.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
Sent: Tuesday, December 07, 2010 10:49 AM
To: [login to unmask email]
Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010

BWDB2UG Quarterly Meeting

!!!! For those Registered for the meeting, both z/OS and LUW,
 Please see the website for session handouts which may be downloaded for your use during the meeting !!!!

www.bwdb2ug.org

To pre-register, please mail the appropriate fee with attendee's and employer's name to:

THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
P.O. BOX 18554
BWI AIRPORT, MARYLAND 21240

All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:

Visit our website, www.bwdb2ug.org, for more information.

When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40

At-the-door for non-members: $50
Meeting Schedule:
8:30 – 9:00 Registration

9:00 – 10:15 DB2 and Work Load Management (WLM)
Mark Rader, IBM

Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.

10:15 – 10:30 Coffee Break

10:30 – 11:45 Enhanced Monitoring support in DB2 v10
Mark Rader, IBM

DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.

11:45 – 12:45 Lunch

12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
John Iczkovits, IBM

Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.

2:00 – 2:15 Break

2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
Paul Walters

Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.

Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.

John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.

Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 07:44:26 -0800
From: Dan Luksetich <[login to unmask email]>
Subject: Re: [SPAM] Betr: [DB2-L] XML challenge

Specifically the problem I am having, both with my attempts and your
suggestion, is that my tags are getting modified. For example...

<name>Bob</name>

becomes...

<name%gt;Bob</name>

Look for a way to preserve the tag as is.

Thanks,
Dan


On Wed, 8 Dec 2010 16:26:20 +0100, Marcel Harleman
<[login to unmask email]> wrote:
> Maybe
>
> SELECT XMLSERIALIZE (
> XMLDOCUMENT(
> XMLCONCAT (
> XMLELEMENT ( NAME "blabla", colname )
> )
> )
> AS CLOB
> INCLUDING XMLDECLARATION
> )
> FROM creator.tablename
>
>
> does work?
>
>
> Regards,
>
> Marcel.
>
>
> ------------------------------------------------------------------------
> De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
> vertrouwelijke informatie met de burger of voor de bekendmaking
> van beslissingen. De Belastingdienst hanteert conventies voor het
> gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is
it!
> *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is
> the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 09:55:04 -0600
From: Willie Favero <[login to unmask email]>
Subject: Re: Baltimore / Washington DB2 Users' Meeting 12/8/2010

SlideShare.com is a great way to share presentations.

Willie

On 12/8/2010 9:08 AM, Sevetson, Phil wrote:
> Henry,
>
> All four of those presentations look chock-full of chewy goodness! Many of those of us who can't make it to your RUG would still love to see the presentations, if the authors are willing to publish them somewhere that we can go to download them. Would you let them know about our interest, please?
>
> I believe the IDUG website has a way to host such things; I'll look around and see what I can find.
>
> --Phil Sevetson
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Henry L Nalven
> Sent: Tuesday, December 07, 2010 10:49 AM
> To: [login to unmask email]
> Subject: [DB2-L] Baltimore / Washington DB2 Users' Meeting 12/8/2010
>
> BWDB2UG Quarterly Meeting
>
> !!!! For those Registered for the meeting, both z/OS and LUW,
>  Please see the website for session handouts which may be downloaded for your use during the meeting !!!!
>
> www.bwdb2ug.org
>
> To pre-register, please mail the appropriate fee with attendee's and employer's name to:
>
> THE BALTIMORE/WASHINGTON DB2 USERS' GROUP
> P.O. BOX 18554
> BWI AIRPORT, MARYLAND 21240
>
> All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:
>
> Visit our website, www.bwdb2ug.org, for more information.
>
> When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)
> Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900
>
> Meeting Fees:
> Pre-registered members: $30
> Pre-registered non-members: $40
> At-the-door for members: $40
>
> At-the-door for non-members: $50
> Meeting Schedule:
> 8:30 – 9:00 Registration
>
> 9:00 – 10:15 DB2 and Work Load Management (WLM)
> Mark Rader, IBM
>
> Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.
>
> 10:15 – 10:30 Coffee Break
>
> 10:30 – 11:45 Enhanced Monitoring support in DB2 v10
> Mark Rader, IBM
>
> DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.
>
> 11:45 – 12:45 Lunch
>
> 12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
> John Iczkovits, IBM
>
> Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.
>
> 2:00 – 2:15 Break
>
> 2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
> Paul Walters
>
> Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.
>
> Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.
>
> John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has an operations background and more than 28 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.
>
> Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2 information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is it! *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 08:17:04 -0800
From: Dan Luksetich <[login to unmask email]>
Subject: Re: Betr: [DB2-L] XML challenge

got it! XMLPARSE did the job!

Thanks for the advice.

Dan


On Wed, 8 Dec 2010 16:26:20 +0100, Marcel Harleman
<[login to unmask email]> wrote:
> Maybe
>
> SELECT XMLSERIALIZE (
> XMLDOCUMENT(
> XMLCONCAT (
> XMLELEMENT ( NAME "blabla", colname )
> )
> )
> AS CLOB
> INCLUDING XMLDECLARATION
> )
> FROM creator.tablename
>
>
> does work?
>
>
> Regards,
>
> Marcel.
>
>
> ------------------------------------------------------------------------
> De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
> vertrouwelijke informatie met de burger of voor de bekendmaking
> van beslissingen. De Belastingdienst hanteert conventies voor het
> gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is
it!
> *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is
> the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 16:30:55 +0000
From: Jim McAlpine <[login to unmask email]>
Subject: DB2 for z/OS - error with UNLOAD utility

I'm getting the following -

DSNU000I 342 17:21:56.24 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID =
UNLOADU
DSNU1044I 342 17:21:56.26 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 342 17:21:56.27 DSNUGUTC - LISTDEF UNLDLIST INCLUDE TABLE
Z30D.T*
DSNU1035I 342 17:21:56.27 DSNUILDR - LISTDEF STATEMENT PROCESSED
SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - TEMPLATE UNLDDS DSN
Z30D.UNLOAD.DATA.&TS. DISP(NEW, CATLG, CATLG) SPACE(
750, 750) TRK UNIT 3390 VOLUMES(VPWRAZ)
DSNU1035I 342 17:21:56.27 DSNUJTDR - TEMPLATE STATEMENT PROCESSED
SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - TEMPLATE PUNCHDS DSN
Z30D.UNLOAD.PARM.&TS. DISP(NEW, CATLG, CATLG) SPACE(1,
1) TRK UNIT 3390 VOLUMES(VPWRAZ)
DSNU1035I 342 17:21:56.27 DSNUJTDR - TEMPLATE STATEMENT PROCESSED
SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - UNLOAD LIST UNLDLIST PUNCHDDN
PUNCHDS UNLDDN UNLDDS
DSNU1033I 342 17:22:06.13 DSNUGULM - PROCESSING LIST ITEM: TABLESPACE
Z30DDA01.SAACMPY
DSNU1221I 342 17:22:06.16 DSNUUNLD - UNLDDN IS NOT SPECIFIED OR SPECIFIED
TEMPLATE UNLDDS IS INVALID FOR MULTIPLE
TABLE SPACES
DSNU012I 342 17:22:06.17 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST
RETURN CODE=8
and I can't see an error with the templates.

Also, if I add PREVIEW to the job it runs to completion and the dataset
names are correctly expanded like so -

DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDZ01.SZZAUDIT
DSNUGPVV - TEMPLATE UNLDDS DSN=Z30D.UNLOAD.DATA.SZZAUDIT
DSNUGPVV - TEMPLATE PUNCHDS DSN=Z30D.UNLOAD.PARM.SZZAUDIT
DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDZ01.SZZCNTRL
DSNUGPVV - TEMPLATE UNLDDS DSN=Z30D.UNLOAD.DATA.SZZCNTRL
DSNUGPVV - TEMPLATE PUNCHDS DSN=Z30D.UNLOAD.PARM.SZZCNTRL
DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDZ01.SZZPLAN
DSNUGPVV - TEMPLATE UNLDDS DSN=Z30D.UNLOAD.DATA.SZZPLAN
DSNUGPVV - TEMPLATE PUNCHDS DSN=Z30D.UNLOAD.PARM.SZZPLAN
DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDZ01.SZZXRST
DSNUGPVV - TEMPLATE UNLDDS DSN=Z30D.UNLOAD.DATA.SZZXRST
DSNUGPVV - TEMPLATE PUNCHDS DSN=Z30D.UNLOAD.PARM.SZZXRST
DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
Any ideas ?

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 10:33:48 -0500
From: Mike Lefebvre <[login to unmask email]>
Subject: CICS TS 2.3

Has anyone tested DB2 V10 with CICS TS 2.3?

Tks.
Mike Lefebvre

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

------------------------------

Date: Wed, 8 Dec 2010 11:41:16 -0500
From: "Doyle, Mark M2" <[login to unmask email]>
Subject: Re: DB2 for z/OS - error with UNLOAD utility

My guess - and is just a guess - 2 tables each having the same TS name (in different databases).

Mark



This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and
any attachments are believed to be free of any virus or other
defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to
ensure that it is virus free and no responsibility is accepted by
JPMorgan Chase & Co., its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use.
If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

------------------------------

Date: Wed, 8 Dec 2010 10:41:56 -0600
From: "Bell, Raymond" <[login to unmask email]>
Subject: Re: DB2 for z/OS - error with UNLOAD utility

Jim,

Just guessing but is the tablespace name unique for your Listdef? You're selecting objects by table name but the Template is using tablespace name - there may be TBs in TSs of the same name, but in different DBs. If that's the case, maybe add &DB to your Template def.

Cheers,


Raymond
PS. OMG, giving suggestions on how to run IBM utilities. Hope no one's watching...

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: 08 December 2010 16:31
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS - error with UNLOAD utility

I'm getting the following -

DSNU000I 342 17:21:56.24 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = UNLOADU
DSNU1044I 342 17:21:56.26 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 342 17:21:56.27 DSNUGUTC - LISTDEF UNLDLIST INCLUDE TABLE Z30D.T*
DSNU1035I 342 17:21:56.27 DSNUILDR - LISTDEF STATEMENT PROCESSED SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - TEMPLATE UNLDDS DSN Z30D.UNLOAD.DATA.&TS. DISP(NEW, CATLG, CATLG) SPACE(
750, 750) TRK UNIT 3390 VOLUMES(VPWRAZ)
DSNU1035I 342 17:21:56.27 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - TEMPLATE PUNCHDS DSN Z30D.UNLOAD.PARM.&TS. DISP(NEW, CATLG, CATLG) SPACE(1,
1) TRK UNIT 3390 VOLUMES(VPWRAZ)
DSNU1035I 342 17:21:56.27 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
DSNU050I 342 17:21:56.27 DSNUGUTC - UNLOAD LIST UNLDLIST PUNCHDDN PUNCHDS UNLDDN UNLDDS
DSNU1033I 342 17:22:06.13 DSNUGULM - PROCESSING LIST ITEM: TABLESPACE Z30DDA01.SAACMPY
DSNU1221I 342 17:22:06.16 DSNUUNLD - UNLDDN IS NOT SPECIFIED OR SPECIFIED TEMPLATE UNLDDS IS INVALID FOR MULTIPLE
TA