Troubleshooting
Problem
This document describes the use of CHGASPACT to quiesce SYSBAS and IASP.
Resolving The Problem
Depending on the parameters used with the CHGASPACT command, the impacts are different. The information below explains the differences between *FRCWRT and *SUSPEND, followed by expert examples and outcomes for various quiesce functionality.
CHGASPACT
*FRCWRT
o Flushes mainstore
*SUSPEND
o Flushes mainstore.
o Halts initiation of new transactions and allows current transactions to reach the next commit boundary.
o Halts initiation of new non-transaction database IOs and allows current IOs to complete.
o Flushes mainstore again.
"Degrees of Quiesce-ness" from a business practice perspective (comments from Development)
CHGASPACT
*FRCWRT
o Flushes mainstore
*SUSPEND
o Flushes mainstore.
o Halts initiation of new transactions and allows current transactions to reach the next commit boundary.
o Halts initiation of new non-transaction database IOs and allows current IOs to complete.
o Flushes mainstore again.
"Degrees of Quiesce-ness" from a business practice perspective (comments from Development)
| 1. | Power down or vary-off: This is the ultimate quiesce because it guarantees everything is flushed to disk and nothing is active. |
| 2. | CHGASPACT ASPDEV(ASP) OPTION(*SUSPEND) SSPTIMO(<xxx>) SSPTIMOACN(*END) gets all transactions to commit boundaries, does not let other database IOs start and other non-database IOs continue to flow. *NOTE - SSPTIMO value is some value which is believed that quiesce could be accomplished. This varied from environment to environment and therefore may require some tuning. |
| 3. | CHGASPACT ASPDEV(ASP) OPTION(*SUSPEND) SSPTIMO(<xxx>) SSPTIMOACN(*CONT) gets as many transactions to commit boundaries; however, there is a chance that long running transactions will still remain active. Non-database activity continues as normal. *NOTE - SSPTIMO value is some value which is believed that quiesce could be accomplished. This varied from environment to environment and therefore may require some tuning. |
| 4. | CHGASPACT OPTION(*FRCWRT) flushes mainstore; however, it does not halt any transactions. |
| 5. | Do nothing and "get what you get"; it is unpredictable. |
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CGgAAM","label":"High Availability"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]
Historical Number
593651301
Was this topic helpful?
Document Information
Modified date:
02 October 2024
UID
nas8N1011640