Online Reorg & Reorg Shrlevel Change

Pearl

Online Reorg & Reorg Shrlevel Change
Hi List,
I'm vary confuse about online Reorg and reorg shrlevel change In DB2 V5 for OS/390. Is it the same? Suppose it's difference, what is it difference?
Thanks.
Pearl
DBA - SCB

Pearl

Online Reorg & Reorg Shrlevel Change
(in response to Sanjeev)
Hi List,
I'm vary confuse about online Reorg and reorg shrlevel change In DB2 V5 for OS/390. Is it the same? Suppose it's difference, what is it difference?
Thanks.
Pearl
DBA - SCB

Sanjeev

Re: Online Reorg & Reorg Shrlevel Change
(in response to Pearl)
Yes, both are same!!
REORG with SHRLEVEL REFERENCE / SHRLEVEL CHANGE are Online Reorg.

Regards

Sanjeev

-----Original Message-----
From: Pearl [mailto:[login to unmask email]
Sent: Tuesday, June 13, 2000 12:24 PM
To: [login to unmask email]
Subject: Online Reorg & Reorg Shrlevel Change


Hi List,
I'm vary confuse about online Reorg and reorg shrlevel change In DB2 V5
for OS/390. Is it the same? Suppose it's difference, what is it difference?

Thanks.

Pearl

DBA - SCB



David Swan

SHRLEVEL CHANGE
(in response to Pearl)
The Standard Life Assurance Company, Standard Life House, 30 Lothian Road,
Edinburgh EH1 2DH, is registered in Scotland (No. SZ4) and regulated by the
Personal Investment Authority. Tel: 0131 225 2552 - calls may be recorded or
monitored. This confidential e-mail is for the addressee only. If received
in error, do not retain/copy/disclose it without our consent and please
return it to us. We virus scan all e-mails but are not responsible for any
damage caused by a virus or alteration by a third party after it is sent.

----------------------------------------------------
-----------------------------------------------------------


We currently run with DB2 SHRLEVEL CHANGE image copies but still copy the
CATALOG in a dedicated window.

I want to change this to allow update activity against the catalog. This
would be consistent with the rest of the backups which run online, albeit in
a quiet period.

My understanding is that there is only potential performance degredation
with such a move and no integrity issues.

Has anyone done this and had any problems?

Many thanks,


David Swan



Leslie Pendlebury-Bowe

Re: SHRLEVEL CHANGE
(in response to David Swan)
David

We do this all the time and does not cause us one single problem.

regards

Leslie Pendlebury-Bowe
DB2 DBA

-----Original Message-----
From: David Swan [mailto:[login to unmask email]
Sent: Monday, July 03, 2000 4:28 PM
To: [login to unmask email]
Subject: SHRLEVEL CHANGE


The Standard Life Assurance Company, Standard Life House, 30 Lothian Road,
Edinburgh EH1 2DH, is registered in Scotland (No. SZ4) and regulated by the
Personal Investment Authority. Tel: 0131 225 2552 - calls may be recorded or
monitored. This confidential e-mail is for the addressee only. If received
in error, do not retain/copy/disclose it without our consent and please
return it to us. We virus scan all e-mails but are not responsible for any
damage caused by a virus or alteration by a third party after it is sent.

----------------------------------------------------
-----------------------------------------------------------


We currently run with DB2 SHRLEVEL CHANGE image copies but still copy the
CATALOG in a dedicated window.

I want to change this to allow update activity against the catalog. This
would be consistent with the rest of the backups which run online, albeit in
a quiet period.

My understanding is that there is only potential performance degredation
with such a move and no integrity issues.

Has anyone done this and had any problems?

Many thanks,


David Swan







**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed.
Sony cannot accept liability for statements made which are clearly
the sender's own and not made on behalf of Sony.
(01)
**********************************************************************



Randy Krueger

Re: SHRLEVEL CHANGE
(in response to Leslie Pendlebury-Bowe)
Our catalog backups run nightly in the off hours and
the only catalog table we found actively update was
SYSUTILX & SYSCOPY, for those we use Shrlevel Change.

The others tables are updated via prime time activties
and have run as Shrlevel reference in the off hours with no conflicts.




"Pendlebury-Bowe, Leslie"
<[login to unmask email] To: [login to unmask email]
.SONY.COM> cc:
Sent by: DB2 Data Base Subject: Re: SHRLEVEL CHANGE
Discussion List
<[login to unmask email]>


07/03/2000 10:40 AM
Please respond to DB2 Data
Base Discussion List





David

We do this all the time and does not cause us one single problem.

regards

Leslie Pendlebury-Bowe
DB2 DBA

-----Original Message-----
From: David Swan [mailto:[login to unmask email]
Sent: Monday, July 03, 2000 4:28 PM
To: [login to unmask email]
Subject: SHRLEVEL CHANGE


The Standard Life Assurance Company, Standard Life House, 30 Lothian Road,
Edinburgh EH1 2DH, is registered in Scotland (No. SZ4) and regulated by the
Personal Investment Authority. Tel: 0131 225 2552 - calls may be recorded
or
monitored. This confidential e-mail is for the addressee only. If received
in error, do not retain/copy/disclose it without our consent and please
return it to us. We virus scan all e-mails but are not responsible for any
damage caused by a virus or alteration by a third party after it is sent.


----------------------------------------------------
-----------------------------------------------------------


We currently run with DB2 SHRLEVEL CHANGE image copies but still copy the
CATALOG in a dedicated window.

I want to change this to allow update activity against the catalog. This
would be consistent with the rest of the backups which run online, albeit
in
a quiet period.

My understanding is that there is only potential performance degredation
with such a move and no integrity issues.

Has anyone done this and had any problems?

Many thanks,


David Swan



the




**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed.
Sony cannot accept liability for statements made which are clearly
the sender's own and not made on behalf of Sony.
(01)
**********************************************************************








Bob Jeandron

Re: SHRLEVEL CHANGE
(in response to Randy Krueger)
We use Change on SYSUTILX and SYSCOPY only. We also do a log archive when the
backup is done. We have had no problems so far.
>>> [login to unmask email]@inter2 07/03/00 10:25AM >>>
The Standard Life Assurance Company, Standard Life House, 30 Lothian Road,
Edinburgh EH1 2DH, is registered in Scotland (No. SZ4) and regulated by the
Personal Investment Authority. Tel: 0131 225 2552 - calls may be recorded or
monitored. This confidential e-mail is for the addressee only. If received
in error, do not retain/copy/disclose it without our consent and please
return it to us. We virus scan all e-mails but are not responsible for any
damage caused by a virus or alteration by a third party after it is sent.

----------------------------------------------------
-----------------------------------------------------------


We currently run with DB2 SHRLEVEL CHANGE image copies but still copy the
CATALOG in a dedicated window.

I want to change this to allow update activity against the catalog. This
would be consistent with the rest of the backups which run online, albeit in
a quiet period.

My understanding is that there is only potential performance degredation
with such a move and no integrity issues.

Has anyone done this and had any problems?

Many thanks,


David Swan








[login to unmask email]

Online Reorg SHRLEVEL CHANGE
(in response to Bob Jeandron)
We have a distributed DB2 application which performs only selects on a
table that needs to be reorganized
frequently. This is a 24 by 7 application and cannot have down time for
maintenance. While running an IBM
ONLINE REORG SHRLEVEL CHANGE today I ran into a problem when trying to
obtain a drain lock on
the DB2 objects during the SWITCH phase. It was only after taking down the
distributed app that my REORG
was able to complete successfully.

Will changing the SQL statement to include WITH UR parameter help the
situation at all? Can the online
REORG perform the drain while an application program is executing with the
uncommitted read (UR)?



Sanjeev (CTS) S

Re: Online Reorg SHRLEVEL CHANGE
(in response to bjnigh@HOUSEHOLD.COM)
Perfect co-ordination of all the SHRLEVEL CHANGE parameters will definitely
help you. Just go through the manual for the description of all the
parameters and then change those accordingly.
In the mean time changing the SQL statements to UR may not give you much
results because CS Claim classes are aquired by the SQLs with UR and DB2
drains the claims(reader and writers) , in this case it looks only reader
claims. In your case it is reader claims. For switch phase DB2 has to drain
everything because it has to rename the object datasets name. For read only
transactions, you can start with MAXRO DEFER and as soon as you find the
transactions is ending or going to end, you can use the ALTER Utility to
change it to some small interval for draining all the claims and further
performing the switch phase. If this is not possible then increasing the
utility timeout is other possiblitiy but that is subsystem wise.

HTH

Regards
Sanjeev

> -----Original Message-----
> From: [login to unmask email] [SMTP:[login to unmask email]
> Sent: Thursday, December 14, 2000 7:48 AM
> To: [login to unmask email]
> Subject: Online Reorg SHRLEVEL CHANGE
>
> We have a distributed DB2 application which performs only selects on a
> table that needs to be reorganized
> frequently. This is a 24 by 7 application and cannot have down time for
> maintenance. While running an IBM
> ONLINE REORG SHRLEVEL CHANGE today I ran into a problem when trying to
> obtain a drain lock on
> the DB2 objects during the SWITCH phase. It was only after taking down
> the
> distributed app that my REORG
> was able to complete successfully.
>
> Will changing the SQL statement to include WITH UR parameter help the
> situation at all? Can the online
> REORG perform the drain while an application program is executing with the
> uncommitted read (UR)?
>
>
>
>
>
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com



Eric Pearson

Re: Online Reorg SHRLEVEL CHANGE
(in response to Sanjeev (CTS) S)
Sorry, this will not do it.
The DRAIN subprocess requires the termination of all CLAIMs.
Even FOR FETCH ONLY WITH UR causes a CLAIM.

Have the programmers add COMMITs.

regards,

eric pearson
NS ITO Database Support


-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, December 13, 2000 9:18 PM
To: [login to unmask email]
Subject: Online Reorg SHRLEVEL CHANGE


We have a distributed DB2 application which performs only selects on a
table that needs to be reorganized
frequently. This is a 24 by 7 application and cannot have down time for
maintenance. While running an IBM
ONLINE REORG SHRLEVEL CHANGE today I ran into a problem when trying to
obtain a drain lock on
the DB2 objects during the SWITCH phase. It was only after taking down the
distributed app that my REORG
was able to complete successfully.

Will changing the SQL statement to include WITH UR parameter help the
situation at all? Can the online
REORG perform the drain while an application program is executing with the
uncommitted read (UR)?