If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > what is recycle means in db2?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-07-11, 15:06
darkmelight darkmelight is offline
Registered User
 
Join Date: Jul 2011
Posts: 5
what is recycle means in db2?

i am new to db2 so i wanted to know what that term means
Reply With Quote
  #2 (permalink)  
Old 10-08-11, 06:57
angoca angoca is offline
Registered User
 
Join Date: Mar 2006
Location: Bogota, Colombia
Posts: 6
Recycle in a DB2 database means that the database has to deactivated and reactivated. You need two thing for that:
  • You need to be sure that the database does not continue activated after the last connection is finished. You will execute a "db2 deactivate db xxx" in order to assure that the database will be down after the last connection.
  • There are not any user connected to the database. You check that with "db2 list applications" and the command should answer that there are not active connections. If there are, and you do not know how to stop naturally, you could a "db2 'force application (xx)'" where xx is the application handle (id) of the list, or you could do a "db2 force application all" and then all connections will be killed.
Recycle for an instance is similar, you need to do a db2stop or db2stop force, and then db2start.

When doing an instance recycle, you will turn off all the databases under that instance.

A recycle is necessary to apply some parameters.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On