[DB2-L] SYSPROC.ADMIN_INFO_SQL

Georg Peter

[DB2-L] SYSPROC.ADMIN_INFO_SQL
Phil, take a look here:

http://www.ibm.com/developerworks/data/library/techarticle/dm-1012capturequery/?ca=drs-

HTH.

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44

Ground Floor, Room 018

70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-27271

PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de < http://www.dzbw.de/ >
----------------------------------------------------------------------



-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Sevetson, Phil
Gesendet: Dienstag, 11. Januar 2011 15:50
An: [login to unmask email]
Betreff: Re: [DB2-L] SYSPROC.ADMIN_INFO_SQL



Hey, Max - where can I read up on what this SP does? ADMIN INFO sounds like a nice broad header - does it have a lot of capabilities?




________________________________


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Max Scarpa
Sent: Tuesday, January 11, 2011 5:36 AM
To: [login to unmask email]
Subject: [DB2-L] SYSPROC.ADMIN_INFO_SQL



Hi all

Just to know, it seems new DB2 10 SYSPROC.ADMIN_INFO_SQL will be retrofitetd to DB2 V9, via APAR PM11941 (still open). More on:

http://www.ibm.com/developerworks/data/library/techarticle/dm-1012capturequery/index.html < http://www.ibm.com/developerworks/data/library/techarticle/dm-1012capturequery/index.html >

HTH

Max Scarpa








________________________________


Introducing IBM® DB2® 10 for z/OS < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


________________________________

Introducing IBM® DB2® 10 for z/OS < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >



Abonnieren Sie unseren Infobrief und erfahren Sie regelmäßig die neuesten Nachrichten über unsere Lösungen, aktuellen Projekte und Entwicklungen. Melden sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief
_______________________________________________________________________________

Datenzentrale Baden-Württemberg, Anstalt des öffentlichen Rechts
Krailenshaldenstr. 44, 70469 Stuttgart
Telefon (0711) 8108-20, Telefax (0711) 8108-21350
E-Mail [login to unmask email], Internet www.datenzentrale.de
Vorstand: Karl Tramer (Vors.) und Harald Schätzle, Vorsitzender des Verwaltungsrats: Gunter Czisch
USt-Id-Nr. DE147794223
_______________________________________________________________________________




_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: SYSPROC.ADMIN_INFO_SQL
(in response to Georg Peter)
Hi Phil

The link I sent in previous post point to an article providing more
informations, did you get it ? From that article:

"The SYSPROC.ADMIN_INFO_SQL stored procedure simplifies the process of
collecting service data about SQL statements and database objects.
ADMIN_INFO_SQL can help IBM Software Support to more quickly resolve your
DB2 for z/OS problems. ADMIN_INFO_SQL is available with DB2 10 for z/OS
(APAR PM25635 PTF UK62150), and will soon be available as a PTF for DB2
9.1 for z/OS (APAR PM11941 OPEN).."

Or look at the APAR text .

HTH

Max Scarpa




From: "Sevetson, Phil" <[login to unmask email]>
To: [login to unmask email]
Date: 11/01/2011 15.51
Subject: Re: [DB2-L] SYSPROC.ADMIN_INFO_SQL
Sent by: IDUG DB2-L <[login to unmask email]>



Hey, Max – where can I read up on what this SP does? ADMIN INFO sounds
like a nice broad header – does it have a lot of capabilities?


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Max Scarpa
Sent: Tuesday, January 11, 2011 5:36 AM
To: [login to unmask email]
Subject: [DB2-L] SYSPROC.ADMIN_INFO_SQL

Hi all

Just to know, it seems new DB2 10 SYSPROC.ADMIN_INFO_SQL will be
retrofitetd to DB2 V9, via APAR PM11941 (still open). More on:

http://www.ibm.com/developerworks/data/library/techarticle/dm-1012capturequery/index.html


HTH

Max Scarpa







The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Sevetson

Re: SYSPROC.ADMIN_INFO_SQL
(in response to Max Scarpa)
Ah! Sorry, I should have looked more closely.
Georg, Max, THANKS!

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Max Scarpa
Sent: Tuesday, January 11, 2011 9:58 AM
To: [login to unmask email]
Subject: Re: [DB2-L] SYSPROC.ADMIN_INFO_SQL

Hi Phil

The link I sent in previous post point to an article providing more informations, did you get it ? From that article:

"The SYSPROC.ADMIN_INFO_SQL stored procedure simplifies the process of collecting service data about SQL statements and database objects. ADMIN_INFO_SQL can help IBM Software Support to more quickly resolve your DB2 for z/OS problems. ADMIN_INFO_SQL is available with DB2 10 for z/OS (APAR PM25635 PTF UK62150), and will soon be available as a PTF for DB2 9.1 for z/OS (APAR PM11941 OPEN).."

Or look at the APAR text .

HTH

Max Scarpa




From: "Sevetson, Phil" <[login to unmask email]>
To: [login to unmask email]
Date: 11/01/2011 15.51
Subject: Re: [DB2-L] SYSPROC.ADMIN_INFO_SQL
Sent by: IDUG DB2-L <[login to unmask email]>
________________________________



Hey, Max - where can I read up on what this SP does? ADMIN INFO sounds like a nice broad header - does it have a lot of capabilities?


________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Max Scarpa
Sent: Tuesday, January 11, 2011 5:36 AM
To: [login to unmask email]
Subject: [DB2-L] SYSPROC.ADMIN_INFO_SQL

Hi all

Just to know, it seems new DB2 10 SYSPROC.ADMIN_INFO_SQL will be retrofitetd to DB2 V9, via APAR PM11941 (still open). More on:

http://www.ibm.com/developerworks/data/library/techarticle/dm-1012capturequery/index.html

HTH

Max Scarpa




________________________________

< http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >



________________________________

< http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >



________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: SYSPROC.ADMIN_INFO_SQL
(in response to Philip Sevetson)
You're welcome.



_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv