Thread Terminator returned error message PTT1062E for pageset names with a wildcard character
Article ID: 8809
Updated On:
Products
Issue/Introduction
In Thread Terminator for Db2 for z/OS (PTT) menu select option '6 Terminate pageset users' to specify the name of a data base and pageset to be freed of all users,
in the pageset name you specify a wildcard character, for example an asterisk '*'.
Pageset . . . . . . . . . *
Encounter the following messages:
PTT1098I THE FOLLOWING COMMAND EXECUTED AT 12:47:54 ON 2017-10-30 BY USER
PTT1036I INPUT: SET FREE DATABASE(xxxxx ) PAGESET(* ) STOP RESTART(R
PTT1063I EXECUTING DB2 COMMAND: -STOP DATABASE(xxxxx ) SPACENAM(* )
PTT1061I DSN9022I !ssid DSNTDDIS 'STOP DATABASE' NORMAL COMPLETION
PTT1058I PAGESET IS NOT ALLOCATED TO DB2.
PTT1057I PAGESET SUCCESSFULLY FREED.
PTT1063I EXECUTING DB2 COMMAND: -START DATABASE(xxxxx ) SPACENAM(* ) A
PTT1062E ERROR PROCESSING DB2 COMMAND CALL. DB2 RETURN CODE 12 REASON CODE 000
PTT1061I DSN9023I !ssid DSNTDDIS 'START DATABASE' ABNORMAL COMPLETION
Resolution
The problem occurred because Thread Termination/Dynamic DSNZPARM (PTT) does not support pageset names values containing the '*' wildcard character.
The -STOP DATABASE command worked correctly. But after the -STOP DATABASE command had been issued, Thread Terminator looked for a pageset named '*' but could not find one.
Since Thread Terminator was unable to find the pageset name specified, it also could not find or terminate the threads using the pageset. Since the threads had not been terminated,
the status of the pagesets was stop pending (STOPP) not STOP. The -START DATABASE command failed because the -START DATABASE command cannot be issued successfully
until the threads using the pagesets have terminated and the status of the pagesets has changed from STOPP to STOP.
You should be able to use the "Thread Terminator Terminate Pageset Users" display successfully provided that you specify the full pageset name.
Feedback
