Re: db2 shutdown

Mike Turner

Re: db2 shutdown
(in response to Avram Friedman)
Stan

Could that be the CASTOUT(NO) option of -STOP DB2 for data sharing? If so,
see redbook SG24-6108, Chapter 5 Operational Enhancements, 5.5 Data sharing
enhancements.

Regards
Mike Turner
Email: [login to unmask email]
Tel: +44 (0)1565-873702
Web: www.michael-turner.ltd.uk

Message text written by DB2 Database Discussion list at IDUG
>Has anyone heard of 'FAST SHUTDWON' ability in DB2 and if so can you guide
me to where to get info about it.

Thanks

Stan Goodwin
<

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

cliff boley

db2 shutdown / IRLM
Speaking of IRLM, I have a few question/comments about it.
Does anything other than DB2 use the IRLM anymore?
I think IMS does/did use it.
Did any other products use it?
I don't know much about the developmental history of DB2 but I suspect that
the IRLM and the directory tables where taken from IMS.

IRLM seems to be treated as a separate subsystem (proc name, maint. level,
DSNames, etc) used by DB2 rather than an integral part of DB2 like DBM1
DIST. Why not bring it into the fold?

Is IMS used anymore? Is it supported?
Well I'm sure someone is still using it, there are some shops still on DB2v4
maybe even v3:-)

cliff:-)





-----Original Message-----
From: BOLEY Maurice C [mailto:[login to unmask email]
Sent: Friday, December 19, 2003 8:16 AM
To: [login to unmask email]
Subject: Re: db2 shutdown


You can also whack the DIST address space instead of IRLM.
(I discovered that the hard way)
cliff:-)

-----Original Message-----
From: Grainger, Phil [mailto:[login to unmask email]
Sent: Friday, December 19, 2003 7:30 AM
To: [login to unmask email]
Subject: Re: db2 shutdown


Two things you can do to speed up the shutdown of DB2

1. Use either SET SYSPARM or some other tool to decrease the DSMAX value to
a VERY small number. Then wait a while whilst DB2 closes the "excess" open
datasets and then issue the -STOP DB2 command (or better still -STOP DB2
MODE(FORCE)

2. Wait until you are SURE there is no activity in DB2, then cancel the IRLM
address space. DB2 fails with an S04F VERY quickly. Because you were not
doing any work in DB2, the restart should be fairly fast too

I prefer option 1!

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of GOODWIN, STANLEY
Sent: Friday, December 19, 2003 2:47 PM
To: [login to unmask email]
Subject: db2 shutdown


Has anyone heard of 'FAST SHUTDWON' ability in DB2 and if so can you guide
me to where to get info about it.

Thanks

Stan Goodwin
CDB322 DB2 Database
(717) 605-4335
DSN 430-4335

My Email address has changed to [login to unmask email]

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bernie O'Connor

Re: db2 shutdown / IRLM
(in response to Mike Turner)
IMS definitely uses IRLM.

Actually, I believe "IMS" is currently the "I" in "IRLM." If you do a
search on google, you'll find references to IMS Resource Lock Manager. In
the late 80's, I believe the "I" stood for "Inter" as in "Inter-Resource
Lock Manager."


Kind regards,
Bernie
..just my opinions...

May your Holiday Season be Bright!
********************************************************************
See www.idug.org for the International DB2 Users Group
See www.mwdug.org for Midwest Database Users Group
********************************************************************




[login to unmask email]
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/19/2003 10:43 AM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: Re: db2 shutdown / IRLM


---------------------- Information from the mail header
-----------------------
Sender: DB2 Data Base Discussion List <[login to unmask email]>
Poster: [login to unmask email]
Subject: Re: db2 shutdown / IRLM
-------------------------------------------------------------------------------

Speaking of IRLM, I have a few question/comments about it.
Does anything other than DB2 use the IRLM anymore?
I think IMS does/did use it.
Did any other products use it?
I don't know much about the developmental history of DB2 but I suspect
that
the IRLM and the directory tables where taken from IMS.

IRLM seems to be treated as a separate subsystem (proc name, maint. level,
DSNames, etc) used by DB2 rather than an integral part of DB2 like DBM1
DIST. Why not bring it into the fold?

Is IMS used anymore? Is it supported?
Well I'm sure someone is still using it, there are some shops still on
DB2v4
maybe even v3:-)

cliff:-)





-----Original Message-----
From: BOLEY Maurice C [mailto:[login to unmask email]
Sent: Friday, December 19, 2003 8:16 AM
To: [login to unmask email]
Subject: Re: db2 shutdown


You can also whack the DIST address space instead of IRLM.
(I discovered that the hard way)
cliff:-)

-----Original Message-----
From: Grainger, Phil [mailto:[login to unmask email]
Sent: Friday, December 19, 2003 7:30 AM
To: [login to unmask email]
Subject: Re: db2 shutdown


Two things you can do to speed up the shutdown of DB2

1. Use either SET SYSPARM or some other tool to decrease the DSMAX value
to
a VERY small number. Then wait a while whilst DB2 closes the "excess" open
datasets and then issue the -STOP DB2 command (or better still -STOP DB2
MODE(FORCE)

2. Wait until you are SURE there is no activity in DB2, then cancel the
IRLM
address space. DB2 fails with an S04F VERY quickly. Because you were not
doing any work in DB2, the restart should be fairly fast too

I prefer option 1!

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of GOODWIN, STANLEY
Sent: Friday, December 19, 2003 2:47 PM
To: [login to unmask email]
Subject: db2 shutdown


Has anyone heard of 'FAST SHUTDWON' ability in DB2 and if so can you guide
me to where to get info about it.

Thanks

Stan Goodwin
CDB322 DB2 Database
(717) 605-4335
DSN 430-4335

My Email address has changed to [login to unmask email]

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of
the office, send the SET DB2-L NO MAIL command to
[login to unmask email] The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: db2 shutdown / IRLM
(in response to cliff boley)
IMS is alive and well being maintained with new and improved versions being issued.
IMS does use the IRLM

The IRLM was introduced before DB2 as an alternative lock manager to PI in IMS.
I one of the original intentions was to support the need for VSCR in the IMS control
region.

I don't know if anything other than DB2 and IMS use it.
IRLM is pretty much a seperate product, I think its current assignment to the DB2
team is strictly a matter of convience to internal IBM operations.

It probally should not be intergrated into DB2 itsself IMHO.

Just my 2 bits on service levels
Diagnose MEPL provides information on running DB2 service levels
F irlmname,STATUS,MAINT provides information on IRLM service levels
[login to unmask email] wrote:

> Speaking of IRLM, I have a few question/comments about it.
> Does anything other than DB2 use the IRLM anymore?
> I think IMS does/did use it.
> Did any other products use it?
> I don't know much about the developmental history of DB2 but I suspect that
> the IRLM and the directory tables where taken from IMS.
>
> IRLM seems to be treated as a separate subsystem (proc name, maint. level,
> DSNames, etc) used by DB2 rather than an integral part of DB2 like DBM1
> DIST. Why not bring it into the fold?
>
> Is IMS used anymore? Is it supported?
> Well I'm sure someone is still using it, there are some shops still on DB2v4
> maybe even v3:-)
>
> cliff:-)
>
> -----Original Message-----
> From: BOLEY Maurice C [mailto:[login to unmask email]
> Sent: Friday, December 19, 2003 8:16 AM
> To: [login to unmask email]
> Subject: Re: db2 shutdown
>
> You can also whack the DIST address space instead of IRLM.
> (I discovered that the hard way)
> cliff:-)
>
> -----Original Message-----
> From: Grainger, Phil [mailto:[login to unmask email]
> Sent: Friday, December 19, 2003 7:30 AM
> To: [login to unmask email]
> Subject: Re: db2 shutdown
>
> Two things you can do to speed up the shutdown of DB2
>
> 1. Use either SET SYSPARM or some other tool to decrease the DSMAX value to
> a VERY small number. Then wait a while whilst DB2 closes the "excess" open
> datasets and then issue the -STOP DB2 command (or better still -STOP DB2
> MODE(FORCE)
>
> 2. Wait until you are SURE there is no activity in DB2, then cancel the IRLM
> address space. DB2 fails with an S04F VERY quickly. Because you were not
> doing any work in DB2, the restart should be fairly fast too
>
> I prefer option 1!
>
> Phil Grainger
> Computer Associates
> Product Manager, DB2
> Tel: +44 (0)161 928 9334
> Fax: +44 (0)161 941 3775
> Mobile: +44 (0)7970 125 752
> [login to unmask email]
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of GOODWIN, STANLEY
> Sent: Friday, December 19, 2003 2:47 PM
> To: [login to unmask email]
> Subject: db2 shutdown
>
> Has anyone heard of 'FAST SHUTDWON' ability in DB2 and if so can you guide
> me to where to get info about it.
>
> Thanks
>
> Stan Goodwin
> CDB322 DB2 Database
> (717) 605-4335
> DSN 430-4335
>
> My Email address has changed to [login to unmask email]
>
> ----------------------------------------------------------------------------
> -----
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". If you will be out of the office, send the SET
> DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
> can be reached at [login to unmask email] Find out the latest on
> IDUG conferences at http://conferences.idug.org/index.cfm
>
> ----------------------------------------------------------------------------
> -----
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". If you will be out of the office, send the SET
> DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
> can be reached at [login to unmask email] Find out the latest on
> IDUG conferences at http://conferences.idug.org/index.cfm
>
> ----------------------------------------------------------------------------
> -----
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". If you will be out of the office, send the SET
> DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
> can be reached at [login to unmask email] Find out the latest on
> IDUG conferences at http://conferences.idug.org/index.cfm
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

--
NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tina Hilton

Re: db2 shutdown / IRLM
(in response to Bernie O'Connor)
You have it backwards. It started out as the IMS Resource Lock Manager, and
then after DB2 started using it IBM renamed it Inter Resource Lock Manager
to make it independent of either software product.

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Friday, December 19, 2003 11:54 AM
To: [login to unmask email]
Subject: Re: db2 shutdown / IRLM



IMS definitely uses IRLM.

Actually, I believe "IMS" is currently the "I" in "IRLM." If you do a
search on google, you'll find references to IMS Resource Lock Manager. In
the late 80's, I believe the "I" stood for "Inter" as in "Inter-Resource
Lock Manager."


Kind regards,
Bernie
..just my opinions...

May your Holiday Season be Bright!
********************************************************************
See www.idug.org for the International DB2 Users Group
See www.mwdug.org for Midwest Database Users Group
********************************************************************



[login to unmask email]
Sent by: DB2 Data Base Discussion List <[login to unmask email]>


12/19/2003 10:43 AM
Please respond to DB2 Database Discussion list at IDUG



To: [login to unmask email]
cc:
Subject: Re: db2 shutdown / IRLM



---------------------- Information from the mail header
-----------------------
Sender: DB2 Data Base Discussion List <[login to unmask email]>
Poster: [login to unmask email]
Subject: Re: db2 shutdown / IRLM
----------------------------------------------------------------------------
---

Speaking of IRLM, I have a few question/comments about it.
Does anything other than DB2 use the IRLM anymore?
I think IMS does/did use it.
Did any other products use it?
I don't know much about the developmental history of DB2 but I suspect that
the IRLM and the directory tables where taken from IMS.

IRLM seems to be treated as a separate subsystem (proc name, maint. level,
DSNames, etc) used by DB2 rather than an integral part of DB2 like DBM1
DIST. Why not bring it into the fold?

Is IMS used anymore? Is it supported?
Well I'm sure someone is still using it, there are some shops still on DB2v4
maybe even v3:-)

cliff:-)





-----Original Message-----
From: BOLEY Maurice C [mailto:[login to unmask email]
Sent: Friday, December 19, 2003 8:16 AM
To: [login to unmask email]
Subject: Re: db2 shutdown


You can also whack the DIST address space instead of IRLM.
(I discovered that the hard way)
cliff:-)

-----Original Message-----
From: Grainger, Phil [mailto:[login to unmask email]
Sent: Friday, December 19, 2003 7:30 AM
To: [login to unmask email]
Subject: Re: db2 shutdown


Two things you can do to speed up the shutdown of DB2

1. Use either SET SYSPARM or some other tool to decrease the DSMAX value to
a VERY small number. Then wait a while whilst DB2 closes the "excess" open
datasets and then issue the -STOP DB2 command (or better still -STOP DB2
MODE(FORCE)

2. Wait until you are SURE there is no activity in DB2, then cancel the IRLM
address space. DB2 fails with an S04F VERY quickly. Because you were not
doing any work in DB2, the restart should be fairly fast too

I prefer option 1!

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of GOODWIN, STANLEY
Sent: Friday, December 19, 2003 2:47 PM
To: [login to unmask email]
Subject: db2 shutdown


Has anyone heard of 'FAST SHUTDWON' ability in DB2 and if so can you guide
me to where to get info about it.

Thanks

Stan Goodwin
CDB322 DB2 Database
(717) 605-4335
DSN 430-4335

My Email address has changed to [login to unmask email]

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". If you will be out of the office, send the
SET DB2-L NO MAIL command to [login to unmask email] The IDUG List
Admins can be reached at [login to unmask email] Find out the
latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm