Salesforce

Is there a parameter that will allow a DBA to control how long it takes to PROSHUT a database down normally?

« Go Back

Information

 
TitleIs there a parameter that will allow a DBA to control how long it takes to PROSHUT a database down normally?
URL Name000027206
Article Number000145932
EnvironmentProduct: OpenEdge
Version: 10.2B, 11.x
OS: All supported platforms
Other: RDBMS
Question/Problem Description
Is there a parameter for PROSHUT that will allow a DBA to control how long it takes to shut a database down normally?

Is there a database broker startup parameter to change the default 10 minute broker value you see in the message below that is associated with a database shutdown since OpenEdge 10.2B.
 
BROKER  0: (15193) The normal shutdown of the database will continue for 10 Min 0 Sec if required.
Steps to Reproduce
Clarifying Information
Error Message(15193) The normal shutdown of the database will continue for 10 Min 0 Sec if required.
(15194) Database activity did not finish before the shutdown timeout expired so the database is performing an immediate shutdown.
Defect Number
Enhancement Number
Cause
Resolution
Shutdown improvements in OpenEdge 10.2B and later introduced the -shutdownTimeout parameter
  • When not otherwise specified  default of 10 minutes is used.
  • The shutdown timeout limits how long the PROSHUT process will wait for the database activity to end. The advantage is to assure remaining connections terminate gracefully allowing transactions to complete and therefore reducing bi recovery time when the database is next opened.
  • If all normal activity ceases before the timeout value is reached, normal shutdown proceeds.
  • When the timeout expires, the shutdown process terminates remaining sessions within 60 seconds
 
The timeout values for the -shutdownTimeout parameter:
 
-shutdownTimeout [ immed | maximum | n [ h | m | s]] 

Where:
  • immed - Shutdown occurs in approximately 60 seconds, regardless of transaction backout status. 
  • maximum - Shutdown occurs in a maximum of 24 hours. 
  • n - Specifies the shutdown timeout value in seconds 60 - 86400 
  • ns - Specifies the shutdown timeout value in seconds 60 - 86400 
  • nm - Specifies the shutdown timeout value in minutes 1 - 1440 
  • nh - Specifies the shutdown timeout value in hours 1 - 24 
Additional Considerations: 
  • The -shutdownTimeout parameter is ignored when forced shutdown (-F) is specified. 
  • DBMAN does not recognise the -shutdownTimeout parameter, only PROSHUT. The shutdown improvements in 10.2B will limit the DBMAN normal shutdown time to the default of 10 minutes.
 
Workaround
Notes
Keyword Phrase
Last Modified Date11/18/2021 4:19 PM

Powered by