DB2 Partitions not equal in 2 different regions.

Chris Bonin

DB2 Partitions not equal in 2 different regions.

I am doing a refresh of one region to another (Prod to ACPT).  The problem I have is that when I use my dsn1copy file, i get an error saying data in wrong object.  I made the partition in ACPTregion with the +1 partition a limit of 999999999 and match the second to last as the last on in the production region.  It keeps getting internal error.

Any help would be appreciated.

 

Srinivas Adupa

DB2 Partitions not equal in 2 different regions.
(in response to Chris Bonin)
The only possibility that I can see here (if DSN1COPY is successful) is to
run the REPAIR DBD.
But as the DSN1COPY itself is failing, I dont think its possible as this
comes under the structural difference.

On Thu, Oct 3, 2019 at 11:33 AM Chris Bonin <[login to unmask email]> wrote:

> I am doing a refresh of one region to another (Prod to ACPT). The problem
> I have is that when I use my dsn1copy file, i get an error saying data in
> wrong object. I made the partition in ACPTregion with the +1 partition a
> limit of 999999999 and match the second to last as the last on in the
> production region. It keeps getting internal error.
>
> Any help would be appreciated.
>
>
>
> -----End Original Message-----
>


--
*Thanks & Regards,*
*Srinivas Adupa*

Kai Stroh

RE: DB2 Partitions not equal in 2 different regions.
(in response to Chris Bonin)

Can you copy&paste the exact error message, including any error codes and reason codes that it might contain?

Is it a message that occurs in the DSN1COPY job? Sounds unlikely because DSN1COPY does not know anything about the limit keys of your partitions.

Or is it an error that you get when you try to access the target object - either using SQL or a Db2 utility - after making the copy?

 

--
Kai Stroh
UBS Hainer
Fast, efficient Db2 z/OS data migrations and renewals. That’s BCV5.
Learn how the Test Data Management Field Guide can help you to improve your own process.

Phil Grainger

DB2 Partitions not equal in 2 different regions.
(in response to Chris Bonin)
What did you specify for NUMPARTS when you did the copy?

Dsn1copy does validate that the datasets you allocate match the partition numbers it finds in the rids

BUT, because it doesn’t have access to the catalog, it relies on YOU supplying the number of partitions so dsn1copy can use the right number of bits for part number

Phil Grainger
Principal Enablement Manager

[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)] [cid:[login to unmask email] [https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]



From: Chris Bonin <[login to unmask email]>
Sent: 03 October 2019 17:33
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - DB2 Partitions not equal in 2 different regions.


I am doing a refresh of one region to another (Prod to ACPT). The problem I have is that when I use my dsn1copy file, i get an error saying data in wrong object. I made the partition in ACPTregion with the +1 partition a limit of 999999999 and match the second to last as the last on in the production region. It keeps getting internal error.

Any help would be appreciated.



-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (49.7k)
  • image002.png (6.7k)
  • image003.jpg (1.6k)
  • image004.png (<1k)

Chris Bonin

RE: DB2 Partitions not equal in 2 different regions.
(in response to Phil Grainger)

Phil, that did the trick. I changed the partition number to what was in Accp and all is well.  Thank you so much for responding to this!

Phil Grainger

DB2 Partitions not equal in 2 different regions.
(in response to Chris Bonin)
Np

H2h

Phil Grainger
Principal Enablement Manager

[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)] [cid:[login to unmask email] [https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]



From: Chris Bonin <[login to unmask email]>
Sent: 10 October 2019 14:10
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - RE: DB2 Partitions not equal in 2 different regions.


Phil, that did the trick. I changed the partition number to what was in Accp and all is well. Thank you so much for responding to this!

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (49.7k)
  • image002.png (6.7k)
  • image003.jpg (1.6k)
  • image004.png (<1k)