Display Thread output

John Vernon

Display Thread output
We are on DB2 ver 5.1
When I execute the following command
-DIS THREAD(*) TYPE(*) DETAIL
I receive the following output:
TPTXA07 T * 28796 POOLBNI00008 TX1 BNXO100P 001F 29757
V436-PGM=BNXO100C.BNXCEHN0, SEC=5, STMNT=654

The first line of output I consider "normal", but I am unfamiliar with the
second line. I have looked in the Command Reference and ReferenceSummary
books for Ver 5, and have not found a satisfactory explanation.....Has
anyone else experienced this output and know what it means???

Many Thanks!



Venkat (PCA) Pillay

Re: Display Thread output
(in response to John Vernon)
That is the collection.pkg getting executed at local subsystem. The current
sql is section 5 and statement # 654 of that package.

For DRDA the DETAIL options is described in the reference manual but it is
not described for LOCAL accesses.

> -----Original Message-----
> From: Vernon, John [SMTP:[login to unmask email]
> Sent: Tuesday, December 14, 1999 10:30 AM
> To: [login to unmask email]
> Subject: Display Thread output
>
> We are on DB2 ver 5.1
> When I execute the following command
> -DIS THREAD(*) TYPE(*) DETAIL
> I receive the following output:
> TPTXA07 T * 28796 POOLBNI00008 TX1 BNXO100P 001F 29757
> V436-PGM=BNXO100C.BNXCEHN0, SEC=5, STMNT=654
>
> The first line of output I consider "normal", but I am unfamiliar with the
> second line. I have looked in the Command Reference and ReferenceSummary
> books for Ver 5, and have not found a satisfactory explanation.....Has
> anyone else experienced this output and know what it means???
>
> Many Thanks!
>
>
>
>
>



John Vernon

Re: Display Thread output
(in response to Venkat (PCA) Pillay)
Venkat,
Many Thanks for the response, however, I'm not sure that I
understand "why" this information is being displayed. It is displayed in a
random fashion, not for all threads executing, and not consistently (in my
opinion)....any idea why?

> -----Original Message-----
> From: Pillay, Venkat (PCA) [SMTP:[login to unmask email]
> Sent: Tuesday, December 14, 1999 10:06 AM
> To: [login to unmask email]
> Subject: Re: Display Thread output
>
> That is the collection.pkg getting executed at local subsystem. The
> current
> sql is section 5 and statement # 654 of that package.
>
> For DRDA the DETAIL options is described in the reference manual but it is
> not described for LOCAL accesses.
>
> > -----Original Message-----
> > From: Vernon, John [SMTP:[login to unmask email]
> > Sent: Tuesday, December 14, 1999 10:30 AM
> > To: [login to unmask email]
> > Subject: Display Thread output
> >
> > We are on DB2 ver 5.1
> > When I execute the following command
> > -DIS THREAD(*) TYPE(*) DETAIL
> > I receive the following output:
> > TPTXA07 T * 28796 POOLBNI00008 TX1 BNXO100P 001F 29757
> > V436-PGM=BNXO100C.BNXCEHN0, SEC=5, STMNT=654
> >
> > The first line of output I consider "normal", but I am unfamiliar with
> the
> > second line. I have looked in the Command Reference and
> ReferenceSummary
> > books for Ver 5, and have not found a satisfactory explanation.....Has
> > anyone else experienced this output and know what it means???
> >
> > Many Thanks!
> >
> >
> >
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
> can
> >
>
>
>
>
>



Venkat (PCA) Pillay

Re: Display Thread output
(in response to John Vernon)
John

Any Thread which is active and in DB2 should show you this
information.

Status "T" means allied, non-distributed thread and next field is act-ind,
an "*" (asterisk) indicates that it is in DB2 and blank indicates otherwise.

> -----Original Message-----
> From: Vernon, John [SMTP:[login to unmask email]
> Sent: Tuesday, December 14, 1999 12:15 PM
> To: [login to unmask email]
> Subject: Re: Display Thread output
>
> Venkat,
> Many Thanks for the response, however, I'm not sure that I
> understand "why" this information is being displayed. It is displayed in
> a
> random fashion, not for all threads executing, and not consistently (in my
> opinion)....any idea why?
>
> > -----Original Message-----
> > From: Pillay, Venkat (PCA) [SMTP:[login to unmask email]
> > Sent: Tuesday, December 14, 1999 10:06 AM
> > To: [login to unmask email]
> > Subject: Re: Display Thread output
> >
> > That is the collection.pkg getting executed at local subsystem. The
> > current
> > sql is section 5 and statement # 654 of that package.
> >
> > For DRDA the DETAIL options is described in the reference manual but it
> is
> > not described for LOCAL accesses.
> >
> > > -----Original Message-----
> > > From: Vernon, John [SMTP:[login to unmask email]
> > > Sent: Tuesday, December 14, 1999 10:30 AM
> > > To: [login to unmask email]
> > > Subject: Display Thread output
> > >
> > > We are on DB2 ver 5.1
> > > When I execute the following command
> > > -DIS THREAD(*) TYPE(*) DETAIL
> > > I receive the following output:
> > > TPTXA07 T * 28796 POOLBNI00008 TX1 BNXO100P 001F 29757
> > > V436-PGM=BNXO100C.BNXCEHN0, SEC=5, STMNT=654
> > >
> > > The first line of output I consider "normal", but I am unfamiliar with
> > the
> > > second line. I have looked in the Command Reference and
> > ReferenceSummary
> > > books for Ver 5, and have not found a satisfactory explanation.....Has
> > > anyone else experienced this output and know what it means???
> > >
> > > Many Thanks!
> > >
> > >
> > >
> visit
> > > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
> > can
> > >
> >
> >
> >
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
> can
> >
>
>
>
>
>



John Vernon

Re: Display Thread output
(in response to Venkat (PCA) Pillay)
Venkat,
What you have indicated is not happening on our system here, so we are
contacting IBM to see if maintenance needs to be added, or if additional
steps need to be taken. Many Thanks for the feedback and information, I'll
let you know what IBM says.....

Best Regards,

John Vernon
DB2 System Administrator
Texas WorkForce Commission
101 East 15th Street
Austin, Texas 78778
Vice-President, Heart of Texas DB2 Users Group
Email: [login to unmask email]
[login to unmask email]
Phone: 512-936-3170
Fax: 512-936-3190
"Ability may get you to the top, but it takes character to keep you there."