MVSFORUMS.com

Ihabermann · Beginner Joined: 26 Jan 2005 Posts: 2 Topics: 1

Hello,

we have a problem with the shutdown of the DB2 database. When
there was an inactive spufi session, then DB2 waits till this session
will be ended without message.
Now I tried
-SSID Display thread
DSNV402I -DB2Y ACTIVE THREADS - 207
NAME ST A REQ ID AUTHID PLAN ASID TOKEN
TSO N 1 USER1 00CA 0 0
DISPLAY ACTIVE REPORT COMPLETE
then:
-SSID Cancel thread(0)
DSNV427I -DB2Y DSNVCT INVALID THREAD '0' SPECIFIED

What can I do ?

Regards
Ilse

kolusu · Posted: Wed Jan 26, 2005 8:29 am Post subject:

Ihabermann,

You can use the DISPLAY thread command to display all the active threads and then issue CANCEL thread command to cancel all the active threads.

-DISPLAY THREAD

-CANCEL THREAD

You can run this process in batch.

Ihabermann · Beginner Joined: 26 Jan 2005 Posts: 2 Topics: 1

Hello Kolusu,

I know these commands.
But these don't work with spufi threads.
You can try it . If you are in the spufi panel with
the processing options and no sql is running,
the you can not cancel this session with cancel thread.

Regards
Ilse

kolusu · Posted: Wed Jan 26, 2005 9:15 am Post subject:

Ihabermann,

Hmm in that case can't you just cancel the USER-ID ?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

s_shivaraj · Posted: Fri Aug 17, 2007 1:00 pm Post subject:

Kolusu,
Can we cancel a User id when a SPUFI query (thread) is executing. I tried several times , it didnt work for me.
_________________
Cheers
Sivaraj S

'Technical Skill is the Master of complexity, while Creativity is the Master of Simplicity'

kolusu · Posted: Sat Aug 18, 2007 7:55 am Post subject:

s_shivaraj,

Do you have authority to issue cancel commands? IF so did you see the token id in the DISPLAY THREAD output? The CANCEL command schedules a thread to be terminated in DB2. To terminate, the thread must be processing within DB2. If the thread does not terminate, it could be Processing outside of DB2, possibly in the application. If that is the case, the thread does not terminate until the application makes a request to DB2. Use the z/OS CANCEL command to terminate the application immediately.

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

s_shivaraj · Posted: Sat Aug 18, 2007 11:28 am Post subject:

kolusu,

I have access to cancel the running User Id's. I hope Canceling a UserId intern process the CANCEL Thread in case of any running DB2 Threads in SPUFI ,etc.

I dont have acess to CANCEL the DB2 Threads, that may be the reason why cancellation is failing for me.
_________________
Cheers
Sivaraj S

'Technical Skill is the Master of complexity, while Creativity is the Master of Simplicity'