Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

COPY TABLESPACE inquiry

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sprikitik

New User


Joined: 29 Jan 2007
Posts: 58
Location: Makati City, Philippines

PostPosted: Thu Jun 10, 2010 4:20 pm    Post subject: COPY TABLESPACE inquiry
Reply with quote

I have created a 'clone' of a Job (JOBA). The clone job is JOBB.

The scenario is this:

JOBA will load data (1000 records) to an empty partitioned table TABLEA and then will do a COPY TABLESPACE XXXXXXXX.XXXXXXXX DSNUM 1 FULL YES into DATASETA

After running JOBA, I will delete all records from the same table and will run JOBB. JOBB will also load the same records loaded by JOBA at the same table and then will also do a COPY TABLESPACE XXXXXXXX.XXXXXXXX DSNUM 1 FULL YES into DATASETB

Im expecting that the UNLOADED files (result of the COPY TABLESPACE of JOBA and JOBB) will be exactly the same when compared but upon comparing, there are a lot of differences. Any idea why the output of the unloads are not the same eventhough both jobs are loading the same records in an empty table?

Thanks!
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Thu Jun 10, 2010 4:38 pm    Post subject:
Reply with quote

Hello There,

You have not mention any thing about Unload step in your jobs . You mentioned that u are running load followed by copy tablespace first partition.You have not mention what query you are using for delete and
secondly is it Load resume or replace ? Did you check the table is empty before running teh first job? Is its multi table tablespace? Please provide load card as well copy stmt of both the jobs.Will surely be able to help you once we will get answer for above queries
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Thu Jun 10, 2010 4:45 pm    Post subject:
Reply with quote

It is not a different sort order of the outputdatasets that causes confusion ?
Back to top
View user's profile Send private message
sprikitik

New User


Joined: 29 Jan 2007
Posts: 58
Location: Makati City, Philippines

PostPosted: Thu Jun 10, 2010 4:59 pm    Post subject:
Reply with quote

guptae wrote:
Hello There,

You have not mention any thing about Unload step in your jobs . You mentioned that u are running load followed by copy tablespace first partition.You have not mention what query you are using for delete and
secondly is it Load resume or replace ? Did you check the table is empty before running teh first job? Is its multi table tablespace? Please provide load card as well copy stmt of both the jobs.Will surely be able to help you once we will get answer for above queries


Thanks for the reply.

Sorry for the confusion, i used the term 'unload' for 'COPY TABLESPACE'. The load is LOAD RESUME. Before running JOBA and JOBB, i will delete the records from spufi (DELETE * FROM TABLEA) to make sure that I'm using an empty table.

Additional details below:

STEP1

LOAD STEP SYSIN

//SYSIN DD *
LOAD DATA LOG NO INTO TABLE TABLEA PART 1 KEEPDICTIONARY RESUME YES
(table definition...)
/*


STEP2

COPY TABLESPACE STEP SYSIN

//SYSIN DD *
COPY TABLESPACE XXXXXXXX.XXXXXXXX DSNUM 1 FULL YES
/*
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Thu Jun 10, 2010 5:02 pm    Post subject:
Reply with quote

Hello There,

I am assuming that before running JOBB you are again deleting the records from the table and no other job is running before your load which
updating the table like insert. And one more Question how you are comparing Imagecopy dataset?
Back to top
View user's profile Send private message
sprikitik

New User


Joined: 29 Jan 2007
Posts: 58
Location: Makati City, Philippines

PostPosted: Thu Jun 10, 2010 5:08 pm    Post subject:
Reply with quote

guptae wrote:
Hello There,

I am assuming that before running JOBB you are again deleting the records from the table and no other job is running before your load which
updating the table like insert. And one more Question how you are comparing Imagecopy dataset?


Yes. Before running JOBA, JOBB i will delete all records to make sure that the table is empty, I'm also positive that no other Job/s is using the table.

I'm comparing the imagecopy using SuperCE Utility.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Thu Jun 10, 2010 5:09 pm    Post subject:
Reply with quote

And what difference you are getting?can you paste few unmatched records of superCE result?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Jun 10, 2010 5:10 pm    Post subject:
Reply with quote

what exactly are the differences presented by the SuperCE Utility output?

and I would not compare image copy files.
for some reason,
I think they contain more data than just the table's column values -
but somebody else will have to make that call, as I don't feel like trying to find out the image-copy record format.

why not just unload to a ps and compare those, which I know only contain column values?
Back to top
View user's profile Send private message
sprikitik

New User


Joined: 29 Jan 2007
Posts: 58
Location: Makati City, Philippines

PostPosted: Thu Jun 10, 2010 5:21 pm    Post subject:
Reply with quote

The differences looks like garbage, it is unreadable. Basically JOBA will be replaced by JOBB that is why i need to compare the imagecopy to make sure everything is still the same
Back to top
View user's profile Send private message
sprikitik

New User


Joined: 29 Jan 2007
Posts: 58
Location: Makati City, Philippines

PostPosted: Thu Jun 10, 2010 5:25 pm    Post subject:
Reply with quote

dbzTHEdinosauer wrote:
what exactly are the differences presented by the SuperCE Utility output?

and I would not compare image copy files.
for some reason,
I think they contain more data than just the table's column values -
but somebody else will have to make that call, as I don't feel like trying to find out the image-copy record format.

why not just unload to a ps and compare those, which I know only contain column values?


Thanks, It is also my understanding that COPY TABLESPACE will contain extra data and not only column values.

Maybe i will try to unload to PS and see if the unloaded data will match.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Jun 10, 2010 5:29 pm    Post subject:
Reply with quote

Quote:
I have created a 'clone' of a Job (JOBA). The clone job is JOBB.


apparently JOBB is not really a clone of JOBA.

there are some differences.

as far as comparing the imagecopy - that is a waste of time.

the results of restoring the imagecopy is what is important,
and that is what you should be comparing.

again,
unload the the results of JOBA and JOBB using something other than imagecopy and compare that.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Jun 10, 2010 5:36 pm    Post subject:
Reply with quote

sprikitik,

Does your table have Identity columns or default timestamp columns, those attributes might also cause the confusion.

Thanks,
Sushanth
Back to top
View user's profile Send private message
sprikitik

New User


Joined: 29 Jan 2007
Posts: 58
Location: Makati City, Philippines

PostPosted: Fri Jun 11, 2010 7:18 am    Post subject:
Reply with quote

Hi All, I followed the suggestion of dbzTHEdinosauer and unloaded the data into ps and all the records matched. Can anyone please provide an explanation why the compare of image does not match?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 11, 2010 8:47 am    Post subject:
Reply with quote

Hello,

Possibly because of what Sushanth mentioned. . .

It might also be:
Quote:
OBID
Specifies that the object identifier (OBID) for the table (a two byte
binary data) is placed in the first two bytes of the output records
unloaded from the table.


Suggest you look at the first records in the files that don't match in hex to see exactly what is different.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Jun 11, 2010 9:25 am    Post subject:
Reply with quote

Sprikitik,

Quote:
Can anyone please provide an explanation why the compare of image does not match?

Run DSN1PRNT utility with FORMAT and NODATA option on both the IC's and compare the output, you will know, what doesn't match.

Thank You,
Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 1 Fri Dec 02, 2016 9:47 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts dataset copy question - REPRO or some... atulxp TSO/ISPF 2 Wed Aug 03, 2016 10:56 pm
No new posts How to copy Tape dataset to unix main... chaky All Other Mainframe Topics 4 Fri Jul 08, 2016 2:52 am
No new posts Using Field names in FILEAID Batch CO... Atul Banke Compuware & Other Tools 2 Wed Jun 29, 2016 9:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us