UNLOAD from Image copy produces zero rows

Mark Vickers

UNLOAD from Image copy produces zero rows
I am concerned that we may have some unrecoverable tables ?!!

We use unloads from image copied to migrate data to test regions and this
one returned zero rows.

I verified that this image copy looks legit - the backup ran and said it
wrote 38 pages - looked at the physical dataset and it contains data (38
rows).

I tried unloads from this image copy using IBM & BMC unloads and got ZERO
(0) rows from.

This was the IBM unload:
//SYSCOPY1 DD DSN=DISSDB2.ICOPYDBP.W44NSBOL(0),DISP=SHR
//SYSPUNCH DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.LOADCTL,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(1,1),RLSE)
//SYSREC DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.DATA,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(175,75),RLSE)
//SYSIN DD *
UNLOAD TABLESPACE WW44N.W44NSBOL
FROMCOPYDDN SYSCOPY1
PUNCHDDN SYSPUNCH
UNLDDN SYSREC
NOSUBS NOPAD
/*

OUTPUT:
********************************* TOP OF DATA
**************************************************************
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = UNLDW44NSBOH

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - UNLOAD TABLESPACE WW44N.W44NSBOH
DSNU650I -DSNP DSNUUGMS - FROMCOPYDDN SYSCOPY1 PUNCHDDN SYSPUNCH UNLDDN
SYSREC NOSUBS NOPAD
DSNU253I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLE WW44N.WCSSTBOH
DSNU252I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLESPACE WW44N.W44NSBOH
DSNU250I DSNUUNLD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00

DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0

******************************** BOTTOM OF DATA
************************************************************

I also did a Change Manager migration to DSNT (it does a recovery with
obid/dbdid translates) using this Image Copy and all worked except that
there are zero rows in the table.

I checked the unload parms and cannot see anything strange that may
exclude rows.

I also ran DSN1COPY against the image copy and it did not report any
errors.

I did a Chg Mgr compare between two companies that use the identical
tables in different databases saw no major differences other than
pri/secqty and index sizes.
I unloaded the other company image copy and it worked fine.

I am running out of ideas here as to this mystery ?

Here is the proof that the image copy we are using seems
legitimate.....................

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Job DBPCSOMN ran at 23:30 last night:

J E S 2 J O B L O G -- S Y S T E M P R O D -- N
O D E J E S 2 4 3 8 1

23.30.03 JOB02961 ---- WEDNESDAY, 17 DEC 2008 ----
23.30.03 JOB02961 IRR010I USERID OMVSKERN IS ASSIGNED TO THIS JOB.

23.30.09 JOB02961 ICH70001I OMVSKERN LAST ACCESS AT 23:30:08 ON
WEDNESDAY, DECEMBER 17, 2008
23.30.09 JOB02961 $HASP373 DBPCSOMN STARTED - INIT 1 - CLASS A - SYS
PROD
23.30.09 JOB02961 IEF403I DBPCSOMN - STARTED - TIME=23.30.09
23.30.09 JOB02961 - --TIMINGS (MINS.)-- ----PAGING COUNTS---
23.30.09 JOB02961 -JOBNAME STEPNAME PROCSTEP RC EXCP CONN TCB
SRB CLOCK SERV PG PAGE SWAP VIO SWAPS
23.30.09 JOB02961 -DBPCSOMN QUIES1 00 38 38 551177
.00 .0 648 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN STEP001 00 13637 8085 551177
.00 .4 28140 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN QUIES2 00 37 39 551177
.00 .0 616 0 0 0 0 0
23.30.38 JOB02961 IEF404I DBPCSOMN - ENDED - TIME=23.30.38
23.30.38 JOB02961 -DBPCSOMN ENDED. NAME- TOTAL TCB
CPU TIME= .03 TOTAL ELAPSED TIME= .4
23.30.38 JOB02961 $HASP395 DBPCSOMN ENDED
------ JES2 JOB STATISTICS ------



IGD101I SMS ALLOCATED TO DDNAME (SYSCPY01)
DSN (DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 )
STORCLAS (DBPIMAGE) MGMTCLAS (DBPIMAGE) DATACLAS (DWHDATA)

VOL SER NOS= PSD00D


IGD107I DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 ROLLED IN,
DDNAME=SYSCPY01


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = DBPCSOMN
DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - COPY TABLESPACE WW44N.W44NSBOH FULL YES SHRLEVEL
REFERENCE COPYDDN SYSCPY01
DSNU400I DSNUBBID - COPY PROCESSED FOR TABLESPACE WW44N.W44NSBOH
NUMBER OF PAGES=38
AVERAGE PERCENT FREE SPACE PER PAGE = 93.78
PERCENT OF CHANGED PAGES = 22.43
ELAPSED TIME=00:00:00

DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 has 38 rows in it and you can see the
data.

thanks,
Mark.




This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Mark Vickers

Re: UNLOAD from Image copy produces zero rows
(in response to Mark Vickers)
Please disregard - table was empty at time of backup.



This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Ray Gaston

Re: UNLOAD from Image copy produces zero rows
(in response to Mark Vickers)
Mark... Our unloads from IC also specify the table name:


//SYSIN DD *
0115 UNLOAD TABLESPACE DB.TS
0117 FROMCOPYDDN FROMDDN
0118 SHRLEVEL CHANGE ISOLATION UR
0120 FROM TABLE CREATOR.TABLENAME HEADER NONE
0122 //


-Ray Gaston

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Mark Vickers
Sent: Thursday, December 18, 2008 1:40 PM
To: [login to unmask email]
Subject: [DB2-L] UNLOAD from Image copy produces zero rows



I am concerned that we may have some unrecoverable tables ?!!

We use unloads from image copied to migrate data to test regions and
this one returned zero rows.

I verified that this image copy looks legit - the backup ran and said it
wrote 38 pages - looked at the physical dataset and it contains data (38
rows).

I tried unloads from this image copy using IBM & BMC unloads and got
ZERO (0) rows from.

This was the IBM unload:
//SYSCOPY1 DD DSN=DISSDB2.ICOPYDBP.W44NSBOL(0),DISP=SHR
//SYSPUNCH DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.LOADCTL,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(1,1),RLSE)
//SYSREC DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.DATA,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(175,75),RLSE)
//SYSIN DD *
UNLOAD TABLESPACE WW44N.W44NSBOL
FROMCOPYDDN SYSCOPY1
PUNCHDDN SYSPUNCH
UNLDDN SYSREC
NOSUBS NOPAD
/*

OUTPUT:
********************************* TOP OF DATA
**************************************************************
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = UNLDW44NSBOH

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC

DSNU050I DSNUGUTC - UNLOAD TABLESPACE WW44N.W44NSBOH

DSNU650I -DSNP DSNUUGMS - FROMCOPYDDN SYSCOPY1 PUNCHDDN SYSPUNCH
UNLDDN SYSREC NOSUBS NOPAD
DSNU253I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLE WW44N.WCSSTBOH
DSNU252I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLESPACE WW44N.W44NSBOH
DSNU250I DSNUUNLD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00

DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0

******************************** BOTTOM OF DATA
************************************************************

I also did a Change Manager migration to DSNT (it does a recovery with
obid/dbdid translates) using this Image Copy and all worked except that
there are zero rows in the table.

I checked the unload parms and cannot see anything strange that may
exclude rows.

I also ran DSN1COPY against the image copy and it did not report any
errors.

I did a Chg Mgr compare between two companies that use the identical
tables in different databases saw no major differences other than
pri/secqty and index sizes.
I unloaded the other company image copy and it worked fine.

I am running out of ideas here as to this mystery ?

Here is the proof that the image copy we are using seems
legitimate.....................

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~
Job DBPCSOMN ran at 23:30 last night:

J E S 2 J O B L O G -- S Y S T E M P R O D --
N O D E J E S 2 4 3 8 1


23.30.03 JOB02961 ---- WEDNESDAY, 17 DEC 2008 ----

23.30.03 JOB02961 IRR010I USERID OMVSKERN IS ASSIGNED TO THIS JOB.

23.30.09 JOB02961 ICH70001I OMVSKERN LAST ACCESS AT 23:30:08 ON
WEDNESDAY, DECEMBER 17, 2008
23.30.09 JOB02961 $HASP373 DBPCSOMN STARTED - INIT 1 - CLASS A - SYS
PROD
23.30.09 JOB02961 IEF403I DBPCSOMN - STARTED - TIME=23.30.09

23.30.09 JOB02961 -
--TIMINGS (MINS.)-- ----PAGING COUNTS---
23.30.09 JOB02961 -JOBNAME STEPNAME PROCSTEP RC EXCP CONN
TCB SRB CLOCK SERV PG PAGE SWAP VIO SWAPS
23.30.09 JOB02961 -DBPCSOMN QUIES1 00 38 38
551177 .00 .0 648 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN STEP001 00 13637 8085
551177 .00 .4 28140 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN QUIES2 00 37 39
551177 .00 .0 616 0 0 0 0 0
23.30.38 JOB02961 IEF404I DBPCSOMN - ENDED - TIME=23.30.38

23.30.38 JOB02961 -DBPCSOMN ENDED. NAME- TOTAL TCB
CPU TIME= .03 TOTAL ELAPSED TIME= .4
23.30.38 JOB02961 $HASP395 DBPCSOMN ENDED

------ JES2 JOB STATISTICS ------





IGD101I SMS ALLOCATED TO DDNAME (SYSCPY01)

DSN (DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 )

STORCLAS (DBPIMAGE) MGMTCLAS (DBPIMAGE) DATACLAS (DWHDATA)

VOL SER NOS= PSD00D




IGD107I DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 ROLLED IN,
DDNAME=SYSCPY01



DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = DBPCSOMN

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC

DSNU050I DSNUGUTC - COPY TABLESPACE WW44N.W44NSBOH FULL YES SHRLEVEL
REFERENCE COPYDDN SYSCPY01
DSNU400I DSNUBBID - COPY PROCESSED FOR TABLESPACE WW44N.W44NSBOH

NUMBER OF PAGES=38

AVERAGE PERCENT FREE SPACE PER PAGE = 93.78

PERCENT OF CHANGED PAGES = 22.43

ELAPSED TIME=00:00:00


DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 has 38 rows in it and you can see the
data.

thanks,
Mark.





This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the
intended recipient, please contact the sender by reply email and delete
all copies of this message.






________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Mike Backes

Re: UNLOAD from Image copy produces zero rows
(in response to Ray Gaston)
Just because an image copy has pages does not mean the table contained
within the tablespace still contains rows of data. When data is
deleted, the underlying vsam pages are changed so the rows are marked
deleted etc., however they still exist. And get backed up by image
copy etc. The is why you must run reorgs to reclaim space from rows
that are deleted etc..



So my guess is that this actual table contains zero current data rows.
Possible due to a mass delete or something. So while you may have a
problem, it probably isn't with the unload from image copy or utilities
as such.



Would be interested to see how many rows are returned when you do a
select * from the table in question, or what a current runstats shows
as to how many rows are in the table.









Mike Backes



From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Mark Vickers
Sent: Thursday, December 18, 2008 12:40 PM
To: [login to unmask email]
Subject: [DB2-L] UNLOAD from Image copy produces zero rows




I am concerned that we may have some unrecoverable tables ?!!

We use unloads from image copied to migrate data to test regions and
this one returned zero rows.

I verified that this image copy looks legit - the backup ran and said it
wrote 38 pages - looked at the physical dataset and it contains data (38
rows).

I tried unloads from this image copy using IBM & BMC unloads and got
ZERO (0) rows from.

This was the IBM unload:
//SYSCOPY1 DD DSN=DISSDB2.ICOPYDBP.W44NSBOL(0),DISP=SHR
//SYSPUNCH DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.LOADCTL,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(1,1),RLSE)
//SYSREC DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.DATA,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(175,75),RLSE)
//SYSIN DD *
UNLOAD TABLESPACE WW44N.W44NSBOL
FROMCOPYDDN SYSCOPY1
PUNCHDDN SYSPUNCH
UNLDDN SYSREC
NOSUBS NOPAD
/*

OUTPUT:
********************************* TOP OF DATA
**************************************************************
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = UNLDW44NSBOH

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC

DSNU050I DSNUGUTC - UNLOAD TABLESPACE WW44N.W44NSBOH

DSNU650I -DSNP DSNUUGMS - FROMCOPYDDN SYSCOPY1 PUNCHDDN SYSPUNCH
UNLDDN SYSREC NOSUBS NOPAD
DSNU253I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLE WW44N.WCSSTBOH
DSNU252I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLESPACE WW44N.W44NSBOH
DSNU250I DSNUUNLD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00

DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0

******************************** BOTTOM OF DATA
************************************************************

I also did a Change Manager migration to DSNT (it does a recovery with
obid/dbdid translates) using this Image Copy and all worked except that
there are zero rows in the table.

I checked the unload parms and cannot see anything strange that may
exclude rows.

I also ran DSN1COPY against the image copy and it did not report any
errors.

I did a Chg Mgr compare between two companies that use the identical
tables in different databases saw no major differences other than
pri/secqty and index sizes.
I unloaded the other company image copy and it worked fine.

I am running out of ideas here as to this mystery ?

Here is the proof that the image copy we are using seems
legitimate.....................

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~
Job DBPCSOMN ran at 23:30 last night:

J E S 2 J O B L O G -- S Y S T E M P R O D --
N O D E J E S 2 4 3 8 1


23.30.03 JOB02961 ---- WEDNESDAY, 17 DEC 2008 ----

23.30.03 JOB02961 IRR010I USERID OMVSKERN IS ASSIGNED TO THIS JOB.

23.30.09 JOB02961 ICH70001I OMVSKERN LAST ACCESS AT 23:30:08 ON
WEDNESDAY, DECEMBER 17, 2008
23.30.09 JOB02961 $HASP373 DBPCSOMN STARTED - INIT 1 - CLASS A - SYS
PROD
23.30.09 JOB02961 IEF403I DBPCSOMN - STARTED - TIME=23.30.09

23.30.09 JOB02961 -
--TIMINGS (MINS.)-- ----PAGING COUNTS---
23.30.09 JOB02961 -JOBNAME STEPNAME PROCSTEP RC EXCP CONN
TCB SRB CLOCK SERV PG PAGE SWAP VIO SWAPS
23.30.09 JOB02961 -DBPCSOMN QUIES1 00 38 38
551177 .00 .0 648 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN STEP001 00 13637 8085
551177 .00 .4 28140 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN QUIES2 00 37 39
551177 .00 .0 616 0 0 0 0 0
23.30.38 JOB02961 IEF404I DBPCSOMN - ENDED - TIME=23.30.38

23.30.38 JOB02961 -DBPCSOMN ENDED. NAME- TOTAL TCB
CPU TIME= .03 TOTAL ELAPSED TIME= .4
23.30.38 JOB02961 $HASP395 DBPCSOMN ENDED

------ JES2 JOB STATISTICS ------





IGD101I SMS ALLOCATED TO DDNAME (SYSCPY01)

DSN (DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 )

STORCLAS (DBPIMAGE) MGMTCLAS (DBPIMAGE) DATACLAS (DWHDATA)

VOL SER NOS= PSD00D




IGD107I DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 ROLLED IN,
DDNAME=SYSCPY01


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = DBPCSOMN

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC

DSNU050I DSNUGUTC - COPY TABLESPACE WW44N.W44NSBOH FULL YES SHRLEVEL
REFERENCE COPYDDN SYSCPY01
DSNU400I DSNUBBID - COPY PROCESSED FOR TABLESPACE WW44N.W44NSBOH

NUMBER OF PAGES=38

AVERAGE PERCENT FREE SPACE PER PAGE = 93.78

PERCENT OF CHANGED PAGES = 22.43

ELAPSED TIME=00:00:00


DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 has 38 rows in it and you can see the
data.

thanks,
Mark.



This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the
intended recipient, please contact the sender by reply email and delete
all copies of this message.





________________________________

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Philip Sevetson

Re: UNLOAD from Image copy produces zero rows
(in response to Mike Backes)
I'd expect to see that result if you'd dropped and recreated the tables
in that tablespace... other than that, I don't see what the cause would
be.



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Mark Vickers
Sent: Thursday, December 18, 2008 1:40 PM
To: [login to unmask email]
Subject: [DB2-L] UNLOAD from Image copy produces zero rows




I am concerned that we may have some unrecoverable tables ?!!

We use unloads from image copied to migrate data to test regions and
this one returned zero rows.

I verified that this image copy looks legit - the backup ran and said it
wrote 38 pages - looked at the physical dataset and it contains data (38
rows).

I tried unloads from this image copy using IBM & BMC unloads and got
ZERO (0) rows from.

This was the IBM unload:
//SYSCOPY1 DD DSN=DISSDB2.ICOPYDBP.W44NSBOL(0),DISP=SHR
//SYSPUNCH DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.LOADCTL,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(1,1),RLSE)
//SYSREC DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.DATA,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(175,75),RLSE)
//SYSIN DD *
UNLOAD TABLESPACE WW44N.W44NSBOL
FROMCOPYDDN SYSCOPY1
PUNCHDDN SYSPUNCH
UNLDDN SYSREC
NOSUBS NOPAD
/*

OUTPUT:
********************************* TOP OF DATA
**************************************************************
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = UNLDW44NSBOH

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC

DSNU050I DSNUGUTC - UNLOAD TABLESPACE WW44N.W44NSBOH

DSNU650I -DSNP DSNUUGMS - FROMCOPYDDN SYSCOPY1 PUNCHDDN SYSPUNCH
UNLDDN SYSREC NOSUBS NOPAD
DSNU253I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLE WW44N.WCSSTBOH
DSNU252I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLESPACE WW44N.W44NSBOH
DSNU250I DSNUUNLD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00

DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0

******************************** BOTTOM OF DATA
************************************************************

I also did a Change Manager migration to DSNT (it does a recovery with
obid/dbdid translates) using this Image Copy and all worked except that
there are zero rows in the table.

I checked the unload parms and cannot see anything strange that may
exclude rows.

I also ran DSN1COPY against the image copy and it did not report any
errors.

I did a Chg Mgr compare between two companies that use the identical
tables in different databases saw no major differences other than
pri/secqty and index sizes.
I unloaded the other company image copy and it worked fine.

I am running out of ideas here as to this mystery ?

Here is the proof that the image copy we are using seems
legitimate.....................

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~
Job DBPCSOMN ran at 23:30 last night:

J E S 2 J O B L O G -- S Y S T E M P R O D --
N O D E J E S 2 4 3 8 1


23.30.03 JOB02961 ---- WEDNESDAY, 17 DEC 2008 ----

23.30.03 JOB02961 IRR010I USERID OMVSKERN IS ASSIGNED TO THIS JOB.

23.30.09 JOB02961 ICH70001I OMVSKERN LAST ACCESS AT 23:30:08 ON
WEDNESDAY, DECEMBER 17, 2008
23.30.09 JOB02961 $HASP373 DBPCSOMN STARTED - INIT 1 - CLASS A - SYS
PROD
23.30.09 JOB02961 IEF403I DBPCSOMN - STARTED - TIME=23.30.09

23.30.09 JOB02961 -
--TIMINGS (MINS.)-- ----PAGING COUNTS---
23.30.09 JOB02961 -JOBNAME STEPNAME PROCSTEP RC EXCP CONN
TCB SRB CLOCK SERV PG PAGE SWAP VIO SWAPS
23.30.09 JOB02961 -DBPCSOMN QUIES1 00 38 38
551177 .00 .0 648 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN STEP001 00 13637 8085
551177 .00 .4 28140 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN QUIES2 00 37 39
551177 .00 .0 616 0 0 0 0 0
23.30.38 JOB02961 IEF404I DBPCSOMN - ENDED - TIME=23.30.38

23.30.38 JOB02961 -DBPCSOMN ENDED. NAME- TOTAL TCB
CPU TIME= .03 TOTAL ELAPSED TIME= .4
23.30.38 JOB02961 $HASP395 DBPCSOMN ENDED

------ JES2 JOB STATISTICS ------





IGD101I SMS ALLOCATED TO DDNAME (SYSCPY01)

DSN (DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 )

STORCLAS (DBPIMAGE) MGMTCLAS (DBPIMAGE) DATACLAS (DWHDATA)

VOL SER NOS= PSD00D




IGD107I DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 ROLLED IN,
DDNAME=SYSCPY01


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = DBPCSOMN

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC

DSNU050I DSNUGUTC - COPY TABLESPACE WW44N.W44NSBOH FULL YES SHRLEVEL
REFERENCE COPYDDN SYSCPY01
DSNU400I DSNUBBID - COPY PROCESSED FOR TABLESPACE WW44N.W44NSBOH

NUMBER OF PAGES=38

AVERAGE PERCENT FREE SPACE PER PAGE = 93.78

PERCENT OF CHANGED PAGES = 22.43

ELAPSED TIME=00:00:00


DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 has 38 rows in it and you can see the
data.

thanks,
Mark.



This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the
intended recipient, please contact the sender by reply email and delete
all copies of this message.





________________________________

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Mark Vickers

Re: UNLOAD from Image copy produces zero rows
(in response to Philip Sevetson)
Ray, we only have one table per space so that normally is not an issue.
Thanks, Mark.




"Gaston, Raymond" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/18/2008 02:59 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] UNLOAD from Image copy produces zero rows






Mark... Our unloads from IC also specify the table name:


//SYSIN DD *
0115 UNLOAD TABLESPACE DB.TS
0117 FROMCOPYDDN FROMDDN
0118 SHRLEVEL CHANGE ISOLATION UR
0120 FROM TABLE CREATOR.TABLENAME HEADER NONE
0122 //


-Ray Gaston

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Mark Vickers
Sent: Thursday, December 18, 2008 1:40 PM
To: [login to unmask email]
Subject: [DB2-L] UNLOAD from Image copy produces zero rows


I am concerned that we may have some unrecoverable tables ?!!

We use unloads from image copied to migrate data to test regions and this
one returned zero rows.

I verified that this image copy looks legit - the backup ran and said it
wrote 38 pages - looked at the physical dataset and it contains data (38
rows).

I tried unloads from this image copy using IBM & BMC unloads and got ZERO
(0) rows from.

This was the IBM unload:
//SYSCOPY1 DD DSN=DISSDB2.ICOPYDBP.W44NSBOL(0),DISP=SHR
//SYSPUNCH DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.LOADCTL,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(1,1),RLSE)
//SYSREC DD DSN=UNLOAD.PGMRMXV.DSNP.WW44N.W44NSBOL.DATA,
// DISP=(NEW,CATLG,DELETE),
// DCB=(DISK.MODEL),
// UNIT=DISK,VOL=SER=XNM806,
// SPACE=(CYL,(175,75),RLSE)
//SYSIN DD *
UNLOAD TABLESPACE WW44N.W44NSBOL
FROMCOPYDDN SYSCOPY1
PUNCHDDN SYSPUNCH
UNLDDN SYSREC
NOSUBS NOPAD
/*

OUTPUT:
********************************* TOP OF DATA
**************************************************************
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = UNLDW44NSBOH

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - UNLOAD TABLESPACE WW44N.W44NSBOH
DSNU650I -DSNP DSNUUGMS - FROMCOPYDDN SYSCOPY1 PUNCHDDN SYSPUNCH UNLDDN
SYSREC NOSUBS NOPAD
DSNU253I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLE WW44N.WCSSTBOH
DSNU252I DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLESPACE WW44N.W44NSBOH
DSNU250I DSNUUNLD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00

DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0

******************************** BOTTOM OF DATA
************************************************************

I also did a Change Manager migration to DSNT (it does a recovery with
obid/dbdid translates) using this Image Copy and all worked except that
there are zero rows in the table.

I checked the unload parms and cannot see anything strange that may
exclude rows.

I also ran DSN1COPY against the image copy and it did not report any
errors.

I did a Chg Mgr compare between two companies that use the identical
tables in different databases saw no major differences other than
pri/secqty and index sizes.
I unloaded the other company image copy and it worked fine.

I am running out of ideas here as to this mystery ?

Here is the proof that the image copy we are using seems
legitimate.....................

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Job DBPCSOMN ran at 23:30 last night:

J E S 2 J O B L O G -- S Y S T E M P R O D -- N
O D E J E S 2 4 3 8 1

23.30.03 JOB02961 ---- WEDNESDAY, 17 DEC 2008 ----
23.30.03 JOB02961 IRR010I USERID OMVSKERN IS ASSIGNED TO THIS JOB.

23.30.09 JOB02961 ICH70001I OMVSKERN LAST ACCESS AT 23:30:08 ON
WEDNESDAY, DECEMBER 17, 2008
23.30.09 JOB02961 $HASP373 DBPCSOMN STARTED - INIT 1 - CLASS A - SYS
PROD
23.30.09 JOB02961 IEF403I DBPCSOMN - STARTED - TIME=23.30.09
23.30.09 JOB02961 - --TIMINGS (MINS.)-- ----PAGING COUNTS---
23.30.09 JOB02961 -JOBNAME STEPNAME PROCSTEP RC EXCP CONN TCB
SRB CLOCK SERV PG PAGE SWAP VIO SWAPS
23.30.09 JOB02961 -DBPCSOMN QUIES1 00 38 38 551177
.00 .0 648 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN STEP001 00 13637 8085 551177
.00 .4 28140 0 0 0 0 0
23.30.38 JOB02961 -DBPCSOMN QUIES2 00 37 39 551177
.00 .0 616 0 0 0 0 0
23.30.38 JOB02961 IEF404I DBPCSOMN - ENDED - TIME=23.30.38
23.30.38 JOB02961 -DBPCSOMN ENDED. NAME- TOTAL TCB
CPU TIME= .03 TOTAL ELAPSED TIME= .4
23.30.38 JOB02961 $HASP395 DBPCSOMN ENDED
------ JES2 JOB STATISTICS ------



IGD101I SMS ALLOCATED TO DDNAME (SYSCPY01)
DSN (DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 )
STORCLAS (DBPIMAGE) MGMTCLAS (DBPIMAGE) DATACLAS (DWHDATA)

VOL SER NOS= PSD00D


IGD107I DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 ROLLED IN,
DDNAME=SYSCPY01



DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = DBPCSOMN
DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - COPY TABLESPACE WW44N.W44NSBOH FULL YES SHRLEVEL
REFERENCE COPYDDN SYSCPY01
DSNU400I DSNUBBID - COPY PROCESSED FOR TABLESPACE WW44N.W44NSBOH
NUMBER OF PAGES=38
AVERAGE PERCENT FREE SPACE PER PAGE = 93.78
PERCENT OF CHANGED PAGES = 22.43
ELAPSED TIME=00:00:00

DISSDB2.ICOPYDBP.W44NSBOH.G4950V00 has 38 rows in it and you can see the
data.

thanks,
Mark.



This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
list archives, FAQ, and delivery preferences are at IDUG.ORG under the
Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more. If you have not yet signed up for
Basic Membership in IDUG, available at no cost, click on Member Services


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
list archives, FAQ, and delivery preferences are at IDUG.ORG under the
Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more. If you have not yet signed up for
Basic Membership in IDUG, available at no cost, click on Member Services




This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Mark Vickers

Re: UNLOAD from Image copy produces zero rows
(in response to Mark Vickers)
RE-SEND - sorry for wasting time here - see my message below..

The table is populated again early the next day, so by the time I looked
at it, it did have rows in it.

Not sure how to go back in time to see exactly how many rows were there
when the copy was taken, all you see is how many pages were copied !

Thanks again.




Mark Vickers <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/18/2008 02:52 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] UNLOAD from Image copy produces zero rows






Please disregard - table was empty at time of backup.


This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
list archives, FAQ, and delivery preferences are at IDUG.ORG under the
Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more. If you have not yet signed up for
Basic Membership in IDUG, available at no cost, click on Member Services




This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Phil Grainger

Re: UNLOAD from Image copy produces zero rows
(in response to Mark Vickers)
To see how many rows there were when the copy was taken, you do exactly what you did do - you unload it (and then believe the output!)

Phil Grainger
CA

________________________________

From: DB2 Data Base Discussion List on behalf of Mark Vickers
Sent: Thu 18/12/2008 21:15
To: [login to unmask email]
Subject: Re: [DB2-L] UNLOAD from Image copy produces zero rows



RE-SEND - sorry for wasting time here - see my message below..

The table is populated again early the next day, so by the time I looked at it, it did have rows in it.

Not sure how to go back in time to see exactly how many rows were there when the copy was taken, all you see is how many pages were copied !

Thanks again.




Mark Vickers <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

12/18/2008 02:52 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc
Subject
Re: [DB2-L] UNLOAD from Image copy produces zero rows






Please disregard - table was empty at time of backup.



This e-mail (and any attachments) may contain information that is confidential and/or protected by law. Any review, use, distribution or disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete all copies of this message.



________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA < http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >





This e-mail (and any attachments) may contain information that is confidential and/or protected by law. Any review, use, distribution or disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete all copies of this message.






________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA < http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Raymond Bell

Re: UNLOAD from Image copy produces zero rows
(in response to Phil Grainger)
Spooky or what? I was just thinking, Mark, you've already done what you need to and Shazam! Mr Grainger 'voices' my thoughts.

Did you say you had a certain recovery product of ours? You could use OUTCOPY ONLY to check how many rows were present at any point in time you chose. But, as Phil says, you have to believe the IC.

Looking foward to Friday...


Raymond

________________________________

From: DB2 Data Base Discussion List on behalf of Grainger, Phil
Sent: Thu 12/18/2008 9:31 PM
To: [login to unmask email]
Subject: Re: [DB2-L] UNLOAD from Image copy produces zero rows



To see how many rows there were when the copy was taken, you do exactly what you did do - you unload it (and then believe the output!)

Phil Grainger
CA

________________________________

From: DB2 Data Base Discussion List on behalf of Mark Vickers
Sent: Thu 18/12/2008 21:15
To: [login to unmask email]
Subject: Re: [DB2-L] UNLOAD from Image copy produces zero rows



RE-SEND - sorry for wasting time here - see my message below..

The table is populated again early the next day, so by the time I looked at it, it did have rows in it.

Not sure how to go back in time to see exactly how many rows were there when the copy was taken, all you see is how many pages were copied !

Thanks again.




Mark Vickers <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

12/18/2008 02:52 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc
Subject
Re: [DB2-L] UNLOAD from Image copy produces zero rows






Please disregard - table was empty at time of backup.



This e-mail (and any attachments) may contain information that is confidential and/or protected by law. Any review, use, distribution or disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete all copies of this message.



________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA < http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >





This e-mail (and any attachments) may contain information that is confidential and/or protected by law. Any review, use, distribution or disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete all copies of this message.






________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA < http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms




______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Mark Vickers

Re: UNLOAD from Image copy produces zero rows
(in response to Raymond Bell)
Raymond, Glad to see you are still there !
Yes and No, We do not have the BMC Recovery Manager, but I know we have
part of it in Chg Mgr, so I did a migrate using the image copy and
recovery/obid/dbid translate and got zero rows.
At that time I was panicking that I had a non recoverable table, but alas,
we still have some VSAM mentatlity and actuall move data around - sad, but
true !!
Caio,
Mark.



"Bell, Raymond" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/18/2008 05:10 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] UNLOAD from Image copy produces zero rows






Spooky or what? I was just thinking, Mark, you've already done what you
need to and Shazam! Mr Grainger 'voices' my thoughts.

Did you say you had a certain recovery product of ours? You could use
OUTCOPY ONLY to check how many rows were present at any point in time you
chose. But, as Phil says, you have to believe the IC.

Looking foward to Friday...


Raymond

________________________________

From: DB2 Data Base Discussion List on behalf of Grainger, Phil
Sent: Thu 12/18/2008 9:31 PM
To: [login to unmask email]
Subject: Re: [DB2-L] UNLOAD from Image copy produces zero rows



To see how many rows there were when the copy was taken, you do exactly
what you did do - you unload it (and then believe the output!)

Phil Grainger
CA

________________________________

From: DB2 Data Base Discussion List on behalf of Mark Vickers
Sent: Thu 18/12/2008 21:15
To: [login to unmask email]
Subject: Re: [DB2-L] UNLOAD from Image copy produces zero rows



RE-SEND - sorry for wasting time here - see my message below..

The table is populated again early the next day, so by the time I looked
at it, it did have rows in it.

Not sure how to go back in time to see exactly how many rows were there
when the copy was taken, all you see is how many pages were copied !

Thanks again.




Mark Vickers <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

12/18/2008 02:52 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc
Subject
Re: [DB2-L] UNLOAD from Image copy produces zero rows






Please disregard - table was empty at time of backup.



This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA <
http://idug.org/lsNA>

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
list archives, FAQ, and delivery preferences are at IDUG.ORG <
http://www.idug.org/lsidug> under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information <
http://www.idug.org/lsconf> , and much more. If you have not yet signed up
for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >





This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.






________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA <
http://idug.org/lsNA>

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
list archives, FAQ, and delivery preferences are at IDUG.ORG <
http://www.idug.org/lsidug> under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information <
http://www.idug.org/lsconf> , and much more. If you have not yet signed up
for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site, you
can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information and much more. If you
have not yet signed up for Basic Membership in IDUG, available at no cost,
click on Member Services at http://www.idug.org/lsms




______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site, you
can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information and much more. If you
have not yet signed up for Basic Membership in IDUG, available at no cost,
click on Member Services at http://www.idug.org/lsms





This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Raymond Bell

Re: UNLOAD from Image copy produces zero rows
(in response to Mark Vickers)
Hi Mark,



Yeah, I'm still here. Although whether I'm still there (or was ever all there) is another matter. I know the bit in your product you're referring to, so Outcopy isn't an option as it's for the utility. But migrating data from the IC, as you found, is. Guess it was a bit of a worry to see, as Bruce Springsteen might have said, 57 pages and nothing on.



Enjoy confusing DB2 as to which cluster's really there. 00C90101's one of my favourites codes. I liked to print it on a baseball bat and threaten Developers with it. Then I woke up.



Tschüß!





Raymond



From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Mark Vickers
Sent: 19 December 2008 13:33
To: [login to unmask email]
Subject: Re: [DB2-L] UNLOAD from Image copy produces zero rows




Raymond, Glad to see you are still there !
Yes and No, We do not have the BMC Recovery Manager, but I know we have part of it in Chg Mgr, so I did a migrate using the image copy and recovery/obid/dbid translate and got zero rows.
At that time I was panicking that I had a non recoverable table, but alas, we still have some VSAM mentatlity and actuall move data around - sad, but true !!
Caio,
Mark.




______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms