DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.

Walter Eachus

DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.
Our Mainframe is being shutdown and the firm wants to keep the
imagecopies for historical purposes but they do not want to keep
around a DB2 subsystem or its associated software.

They are keeping a very, very basic mainframe for this purpose.

They want a utility to read the imagecopy and the output being a dataset
that the data can be read with the "naked" eye ( e.g. DECIMAL
is now ZONED DECIMAL).

Does any 3rd Party utility exist like this ?

Thanks.

Walt Eachus
Barclays Capital DB2 z/OS DBA

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Mike Bell

Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.
(in response to Walter Eachus)

Not that I know of - I have heard of people trying to extract data from
image copies and it seems like the only soulution is to build a DB2
subsystem, create a clone table, and use DSN1COPY to put the data back.

It would be a lot easier to either
1. unload the data in mainframe format and keep copybooks for each table
Or
2. unload the data in character format using DSNTIAUL and a SQL statement
that converts every internal format to display.

Something like
SELECT '"' CONCAT charactercolumn CONCAT '"'
CONCAT ',' CONCAT RTRIM (CHAR(numbericcolumn))


You should verify that you can load the data into DB2 using FORMAT
DELIMITED. You might try loading a subset of the data into EXCEL or
something for an alternative display method.

Yes, the display format uses more space but you can burn it to a DVD or keep
it on a server or you could even zip it.

Mike
HLS Technologies

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Walter Eachus
Sent: Monday, February 22, 2010 11:31 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2
Subsystem.

Our Mainframe is being shutdown and the firm wants to keep the imagecopies
for historical purposes but they do not want to keep around a DB2 subsystem
or its associated software.

They are keeping a very, very basic mainframe for this purpose.

They want a utility to read the imagecopy and the output being a dataset
that the data can be read with the "naked" eye ( e.g. DECIMAL is now ZONED
DECIMAL).

Does any 3rd Party utility exist like this ?

Thanks.

Walt Eachus
Barclays Capital DB2 z/OS DBA

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Philip Sevetson

Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.
(in response to Chris Hoelscher)
Sounds like you need to run a lot of UNLOADs, Walt. DB2 UNLOAD will take imagecopy datasets as input, but it requires the presence of the catalog and a working DB2 system.

I don't think it's _possible_ for a program to read an imagecopy, without a lot of information that's normally present in the DB2 Catalog and Directory. You need column definitions, DBID/OBID/PSID information, and of course the compression dictionary if your datasets are compressed (You could wind up with an incremental copy but no compression dictionary, and thus have no way to interpret the data at all)

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Walter Eachus
Sent: Monday, February 22, 2010 12:31 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.

Our Mainframe is being shutdown and the firm wants to keep the
imagecopies for historical purposes but they do not want to keep
around a DB2 subsystem or its associated software.

They are keeping a very, very basic mainframe for this purpose.

They want a utility to read the imagecopy and the output being a dataset
that the data can be read with the "naked" eye ( e.g. DECIMAL
is now ZONED DECIMAL).

Does any 3rd Party utility exist like this ?

Thanks.

Walt Eachus
Barclays Capital DB2 z/OS DBA

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Chris Hoelscher

Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.
(in response to Mike Bell)
They want a utility to read the imagecopy and the output being a dataset
that the data can be read with the "naked" eye ( e.g. DECIMAL
is now ZONED DECIMAL).
--------------------------------------------


would not an unload from an imagecopy do the trick ?

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
[login to unmask email]

you only need to test the programs that you want to work correctly





The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Philip Sevetson

Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.
(in response to Philip Sevetson)
I think the best for that would be to specify "DELIMITED" in the unload. That way you get CSV format.

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
Sent: Monday, February 22, 2010 1:15 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.

They want a utility to read the imagecopy and the output being a dataset
that the data can be read with the "naked" eye ( e.g. DECIMAL
is now ZONED DECIMAL).
--------------------------------------------


would not an unload from an imagecopy do the trick ?

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
[login to unmask email]

you only need to test the programs that you want to work correctly




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
________________________________

[ http://www.idug.org/partners/www/images/4992e0ad2d01c9c12dd8a4e7a161cd08.gif ] < http://www.idug.org/top-spotlight/mentor.html >

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 * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Randy Bright

Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.
(in response to Philip Sevetson)
Unload Plus for DB2 from BMC Software will read an Image Copy and output a sequential dataset. It does require a DB2 subsystem to be available, but the table does not have to be defined to the DB2 subsystem, you just have to supply the correct DDL for the table to Unload Plus and it will read the Image Copy and output a sequential dataset in the format you want. This does not fit all your requirements, but I don't know of an existing utility that will read an Image Copy, dissect the rows and output a sequential dataset if you don't have a "DB2 subsystem and the associated software" available.

Contact me off-list if you want more information.

Randy Bright
Solutions Architect
DB2 Utilities
BMC Software

phone: 512.340.6014

10431 Morado Circle
Austin, TX 78759




-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Walter Eachus
Sent: Monday, February 22, 2010 11:31 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.

Our Mainframe is being shutdown and the firm wants to keep the
imagecopies for historical purposes but they do not want to keep
around a DB2 subsystem or its associated software.

They are keeping a very, very basic mainframe for this purpose.

They want a utility to read the imagecopy and the output being a dataset
that the data can be read with the "naked" eye ( e.g. DECIMAL
is now ZONED DECIMAL).

Does any 3rd Party utility exist like this ?

Thanks.

Walt Eachus
Barclays Capital DB2 z/OS DBA

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

steen rasmussen

Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.
(in response to Randy Bright)
I can see Randy already replied with the BMC solution J

CA Fast Unload can unload from an image copy even though the table
doesn't exist. You just need to supply the TABLE DDL, and you can then
use all the different output formats you want.



Steen Rasmussen
CA

Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS





From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris
Hoelscher
Sent: Monday, February 22, 2010 12:15 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a
DB2 Subsystem.



They want a utility to read the imagecopy and the output being a dataset

that the data can be read with the "naked" eye ( e.g. DECIMAL
is now ZONED DECIMAL).
--------------------------------------------


would not an unload from an imagecopy do the trick ?

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
[login to unmask email]

you only need to test the programs that you want to work correctly




The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you
receive this material/information in error, please contact the sender
and delete or destroy the material/information.

________________________________

IDUG Mentors - A rewarding experience for everyone!
< http://www.idug.org/top-spotlight/mentor.html >

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 * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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