CA Thread Terminator got error message PTT1062E for pageset names with a wildcard character

Document ID : KB000008809
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

In Thread Terminator 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 . . . . . . . . . *
 
You will get the following messages.
 
PTT1098I THE FOLLOWING COMMAND EXECUTED AT 12:47:54 ON 2017-10-30 BY USER RAUJO
PTT1036I INPUT:  SET FREE DATABASE(HSYDEV  ) PAGESET(*       ) STOP   RESTART(R
PTT1063I EXECUTING DB2 COMMAND: -STOP DATABASE(HSYDEV  ) SPACENAM(*        )  
PTT1061I DSN9022I  !D11A DSNTDDIS 'STOP DATABASE' NORMAL COMPLETION           
PTT1058I PAGESET IS NOT ALLOCATED TO DB2.                                     
PTT1057I PAGESET SUCCESSFULLY FREED.                                          
PTT1063I EXECUTING DB2 COMMAND: -START DATABASE(HSYDEV  ) SPACENAM(*        ) A
PTT1062E ERROR PROCESSING DB2 COMMAND CALL.  DB2 RETURN CODE 12 REASON CODE 000
PTT1061I DSN9023I  !D11A 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.