Skip to main content

developerWorks >  Information Management  >  Forums  >  DB2 for i  >  developerWorks

Error in restoring schema    Point your RSS reader here for a feed of the latest messages in this thread


     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
This question is not answered.

Permlink Replies: 4 - Pages: 1 - Last Post: Nov 5, 2009 3:33 AM Last Post By: Mike148 Threads: [ Previous | Next ]
Mike148

Posts: 14
Registered: May 21, 2009 12:42:44 AM
Error in restoring schema
Posted: Nov 03, 2009 05:45:12 AM
 
Click to report abuse...   Click to reply to this thread Reply
Hi I am trying to restore a db2 schema to another schema on the same system.
Basically we want to replicate a collection for testing purpose.

But I am facing errors on the rstlib command and not all objects are being restored properly.
Mainly journals are not restored.

Problem with data area QDFTJRN in library TESTSCHEMA, reason code 2
Journal identifier X'8570001AF33AFA7E018D' is currently in use.
File ROLE in library TESTSCHEMA not found.
File ROLE in library TESTSCHEMA not found.

We are using V5 R4. Is it necessary to stop journalling on parent schema before restore operation ?

I followed the article here. Any clue guys ?

Regards, Mike.
Mike148

Posts: 14
Registered: May 21, 2009 12:42:44 AM
Re: Error in restoring schema
Posted: Nov 03, 2009 11:40:10 PM   in response to: Mike148 in response to: Mike148's post
 
Click to report abuse...   Click to reply to this thread Reply
Hi guys, anybody ? :(
CRPence@vnet.ib...

Posts: 1
Registered: Nov 04, 2009 06:24:50 PM
Re: Error in restoring schema
Posted: Nov 04, 2009 06:28:44 PM   in response to: Mike148 in response to: Mike148's post
 
Click to report abuse...   Click to reply to this thread Reply
I replied at the following:
news://news.software.ibm.com:119/hcplvl$1643a$1@news.boulder.ibm.com

Seems DeveloperWorks has been failing to copy messages into their web interface from the news interface.

There is also an apparent problem with &lt&gt appearing together being dropped when its web messages appear in the news interface. Testing here, bracketed: [ ]

Regards, Chuck
Mike148

Posts: 14
Registered: May 21, 2009 12:42:44 AM
Re: Error in restoring schema
Posted: Nov 05, 2009 12:00:16 AM   in response to: CRPence@vnet.ibm.com in response to: CRPence@vnet.ibm.com's post
 
Click to report abuse...   Click to reply to this thread Reply
Can you please just paste the message here in this thread? I cant follow the link its not working.
Regards,Mike.
Mike148

Posts: 14
Registered: May 21, 2009 12:42:44 AM
Re: Error in restoring schema
Posted: Nov 05, 2009 03:33:37 AM   in response to: CRPence@vnet.ibm.com in response to: CRPence@vnet.ibm.com's post
 
Click to report abuse...   Click to reply to this thread Reply
Hey hello,

I have stopped journaling on the parent schema now & now I am facing other problems primarily exceptions on restoring the journals to the new schema and with the data area.

Message . . . . : Problem with data area QDFTJRN in library TESTSCHEMA,
reason code 2.

Cause . . . . . : There was a problem with the QDFTJRN data area. The
problem is due to reason code 2. The reason codes are:
*1 -- The data area is not type CHAR, does not have a length of 24 or
greater, or the data cannot be read.
2 -- The data area does not contain the expected special values.

Message . . . . : Cannot restore receiver QSQJRN0108 into library
TESTSCHEMA.

Cause . . . . . : Journal receiver QSQJRN0108 cannot be restored into
library TESTSCHEMA because the library is not the original library for the
journal receiver in the original ASP group nor the redirected library in the
redirected ASP group if the journal receiver is to be associated with a
remote journal.
The saved receiver was originally associated with local journal QSQJRN in
*library PAKRE in ASP group SYSBAS. The following remote journal information
was saved with the journal receiver:
*-- The redirected *TYPE1 remote journal name is N.
*-- The redirected *TYPE1 remote journal library name is N.

What I did was to create a data area on the new schema like this

*CRTDTAARA DTAARA(TESTSCHEMA/QDFTJRN) TYPE(*CHAR) LEN(40) VALUE('TESTSCHEMA*
QSQJRN')

Data area corrected successfully.

Then changed the data area to map with the parent schema like this

*CHGDTAARA DTAARA(TESTSCHEMA/QDFTJRN (21 20)) VALUE('*ALL RSTOVRJRN')

Although we are using V5r4 I dont get any error or success message on the command above.

Anybody can tell me what's wrong ? Am I doing something wrong here ?

Regards, Mike.

 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums