Will BMC load resume replace on partition requires locking on the entire tablespace to switch the datasets

VADDADI VAMSI ANIL

Will BMC load resume replace on partition requires locking on the entire tablespace to switch the datasets

Hi All,

 

One of online insert process is getting failed with the following error in the logs.

049 CORRELATION-ID=
049 CONNECTION-ID=RRSAF
050 REASON 00C9008E
050 TYPE 00000210
050 NAME XXXXXXX.XXXXXXXX 00000121

We did analyse and found that one of the load replace on different partition other than 121 is also executing during the same time.

We are using the following load card in your load replace job

LOAD DATA RESUME YES
COPY NO
COPYPEND NO
ENUMROWS 200
BMCSTATS NO
UPDATEDB2STATS YES
DELETEFILES YES
SYSDISC YES
WORKDDN SYSUT1
ERRDDN SYSERR
SORTDEVT SYSDA
COPYDDN BMCCPY1
SORTNUM 32
INTO TABLE XXXXXXX 032 REPLACE

 

Will load resume with replace on particular partition does require lock on the entire object

 

Regards,

Vamsi

Steen Rasmussen

Will BMC load resume replace on partition requires locking on the entire tablespace to switch the da
(in response to VADDADI VAMSI ANIL)
What about NPI’s ?

Steen

From: VADDADI VAMSI ANIL [mailto:[login to unmask email]
Sent: Friday, May 19, 2017 4:13 PM
To: [login to unmask email]
Subject: [DB2-L] - Will BMC load resume replace on partition requires locking on the entire tablespace to switch the datasets


Hi All,



One of online insert process is getting failed with the following error in the logs.

049 CORRELATION-ID=
049 CONNECTION-ID=RRSAF
050 REASON 00C9008E
050 TYPE 00000210
050 NAME XXXXXXX.XXXXXXXX 00000121

We did analyse and found that one of the load replace on different partition other than 121 is also executing during the same time.

We are using the following load card in your load replace job

LOAD DATA RESUME YES
COPY NO
COPYPEND NO
ENUMROWS 200
BMCSTATS NO
UPDATEDB2STATS YES
DELETEFILES YES
SYSDISC YES
WORKDDN SYSUT1
ERRDDN SYSERR
SORTDEVT SYSDA
COPYDDN BMCCPY1
SORTNUM 32
INTO TABLE XXXXXXX 032 REPLACE



Will load resume with replace on particular partition does require lock on the entire object



Regards,

Vamsi

-----End Original Message-----

Daniel Luksetich

Will BMC load resume replace on partition requires locking on the entire tablespace to switch the da
(in response to Steen Rasmussen)
I would remove the RESUME YES



LOAD DATA
COPY NO
COPYPEND NO
ENUMROWS 200
BMCSTATS NO
UPDATEDB2STATS YES
DELETEFILES YES
SYSDISC YES
WORKDDN SYSUT1
ERRDDN SYSERR
SORTDEVT SYSDA
COPYDDN BMCCPY1
SORTNUM 32
INTO TABLE XXXXXXX 032 REPLACE

That causes a tablespace level lock



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Chairman

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: Rasmussen, Steen [mailto:[login to unmask email]
Sent: Saturday, May 20, 2017 2:12 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Will BMC load resume replace on partition requires locking on the entire tablespace to switch the datasets



What about NPI’s ?



Steen



From: VADDADI VAMSI ANIL [mailto:[login to unmask email]
Sent: Friday, May 19, 2017 4:13 PM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - Will BMC load resume replace on partition requires locking on the entire tablespace to switch the datasets



Hi All,



One of online insert process is getting failed with the following error in the logs.

049 CORRELATION-ID=
049 CONNECTION-ID=RRSAF
050 REASON 00C9008E
050 TYPE 00000210
050 NAME XXXXXXX.XXXXXXXX 00000121

We did analyse and found that one of the load replace on different partition other than 121 is also executing during the same time.

We are using the following load card in your load replace job

LOAD DATA RESUME YES
COPY NO
COPYPEND NO
ENUMROWS 200
BMCSTATS NO
UPDATEDB2STATS YES
DELETEFILES YES
SYSDISC YES
WORKDDN SYSUT1
ERRDDN SYSERR
SORTDEVT SYSDA
COPYDDN BMCCPY1
SORTNUM 32
INTO TABLE XXXXXXX 032 REPLACE



Will load resume with replace on particular partition does require lock on the entire object



Regards,

Vamsi



-----End Original Message-----



-----End Original Message-----