Db2 Admin Tool processing flow

After a panel is displayed, Db2® Admin Tool examines the variables and processes the instructions.

Db2 Admin Tool examines the variables and processes the instructions according to the following rules:

  • If the user presses END, the previous panel is displayed.
  • If variable ISPFSTMT is set, all ISPF statements are processed first.
  • If variable SQLSTMT is set, the SQL statements are processed one by one. If DB2® returns rows, the result on the panel named in the variable PANEL is displayed. If the variable PANEL is not set, the default panel is displayed.
  • If the variable PANEL is set, the specified panel is displayed.
  • If the variable DB2ACMD is set, the Db2 Admin Tool commands are processed.

The process flow that Db2 Admin Tool follows is shown in the following figure.

Figure 1. DB2 Admin logic diagram

This flow diagram begins with an oval at the top that contains the word "Start". Connected below Start is a box containing "Display current PANEL". Connected below this is a diamond containing "User pressed END". Moving to the right with a Yes decision, an arrow takes you to a box containing "Return to previous display", which then connects back to the Start area. A No decision takes you below to another diamond that contains "Any ISPF statements?" If a Yes, you move to the right to a box containing "Execute first ISPF statement." and then further right to a diamond containing "More ISPF statements?" If Yes, you return to the "Execute first ISPF statement" box. If no, you move to the next diamond down the main tree. This next diamond contains "Any SQL statements?" If yes, you move to the right to a box containing "Execute first SQL statement" and then further right to a diamond that asks "Any rows in result?" If yes, the next diamond to the right asks if a "PANEL specified". If yes, you move to the right to a box containing "Display rows on specified PANEL." If no, move down to a box containing "Display rows on default PANEL." In either case, you move down to the next decision point—a diamond that asks "More SQL statements?" If yes, you move back to the "Execute first SQL statement" box. If no, you move back to the main tree to the next diamond that asks "Any PANEL specified?" If yes, you move to the right to a box containing "Display PANEL specified." A note here indicates that "all displays cause DB2 Admin to start from top." If no to "Any PANEL specified", you move down to the next diamond that asks "Any DB2ACMDS?" If yes, move to the right to a box containing "Execute command." If no, move to the final oval on the main tree that contains "End."