If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DSN1COPY error - SP MAP PAGE ERROR

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-25-10, 06:25
nowexam1 nowexam1 is offline
SPAMMER
 
Join Date: May 2010
Posts: 4
DSN1COPY error - SP MAP PAGE ERROR

Hi,

My database has only one table which is segmented and has wround 20 M rows. This tablespace has 2 VSAM datasets A001 and A002 at the source and also in the target.

I am using the image copy to refresh target environment using DSN1COPY.

The below error says of OBID 16 which is not the right identifier for the tablespace from the catalog or from DSN1PRNT.

So I am sure that sysxlat input is 100% right.
As I want the same data of the table at the time IC was taken, I need to know how to solve this problem.


The details are below.

//S000270 EXEC PGM=DSN1COPY,COND=(0,NE),TIME=30,REGION=0M,

// PARM='RESET,FULLCOPY,OBIDXLAT,PAGESIZE(32K)'

//STEPLIB DD DSN=SYS3.DB2.DBG5.LOAD.AUTH,DISP=SHR

//SYSUT1 DD DSN=SCHELLA.OPTDBG5.DODA0957.H0957000.D,

// DISP=OLD,DCB=BUFNO=20

//SYSUT2 DD DISP=OLD,AMP=('AMORG,BUFND=41'),

// DSN=DBG5ODB.DSNDBC.DODB0957.H0957000.I0001.A001

//SYSPRINT DD SYSOUT=*

//SYSXLAT DD *

25319,-16146

4,6

9,7

3,3

//*


Error :



DSN1998I INPUT DSNAME = SCHELLA.OPTDBG5.DODA0957.H0957000.D , SEQ

DSN1997I OUTPUT DSNAME = DBG5ODB.DSNDBC.DODB0957.H0957000.I0001.A001 , VSAM

DSN1987I DSN1TRAN SP MAP PAGE CONTAINING OBID 0016 HAS NO MATCHING VALUE IN THE SYSXLAT FILE


Regards,
Sangita
Reply With Quote
  #2 (permalink)  
Old 05-25-10, 16:01
schintala schintala is offline
Registered User
 
Join Date: Apr 2005
Location: USA
Posts: 119
Looks like error in specifying the source OBID in SYSXLAT DD statement. Are you sure the OBID mentioned in DD card are correct? BTW, how did you get them, did you run SQL against catalogues or DSN1PRNT util? Double check the values of OBID, PSID and DBID at both source and target.
Reply With Quote
  #3 (permalink)  
Old 05-25-10, 20:29
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by schintala View Post
Are you sure the OBID mentioned in DD card are correct? BTW, how did you get them
Relax, this guy just copy-pastes somebody else's messages. He's here for link spamming, not knowledge.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On