Betr.: programs like DSNACOLN, DSNAPRKY, DSNAFNKY .......

Hessel Rus

Betr.: programs like DSNACOLN, DSNAPRKY, DSNAFNKY .......
Peter,

I take a look on the DB2 development system at sysibm.syspackage and found
in the VERSION column for these packages (in collection DSNASPCC):
UQ82361, UQ79255, UQ82361 and UQ82361. Are these numbers identification of
fixes or whatever? Google shows a lot of references.

Met vriendelijke groeten,
Hessel



"Peter, Georg" <[login to unmask email]>
Verzonden door: DB2 Data Base Discussion List <[login to unmask email]>
22-12-2004 12:13
Antwoord a.u.b. aan
DB2 Database Discussion list at IDUG <[login to unmask email]>


Aan
[login to unmask email]
Cc

Onderwerp
programs like DSNACOLN, DSNAPRKY, DSNAFNKY .......






Collegues,

while monitoring our DB2 OS/390 V6 subsystem, I saw some programs like
DSNACOLN, DSNAPRKY, DSNAFNKY and DSNATBLS. These programs are unknown for
me.....

These programms accessed tables, e.g. SYSIBM . SQTCOLUMNS, SYSIBM .
SQTPRIMARYKEYS, SYSIBM . SQTFOREIGNKEYS and SYSIBM . SQTTABLES have the
TYPE = G (temporary tables).

It may be a stupid question, but: Does anyone know what these programs are
doing ? And what is the reason for these temporary tables ?

Any comments, thoughts, experiences are highly appreciated.

Thanks in advance.

With kind regards - mit freundlichen Gruessen,
Georg H. Peter c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Software Development & Technology Center
Knowledge Center Database Systems
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------
"Every action is a p o s i t i v e action, even if it has a negative
result."

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Moschelli Mauro

Re: programs like DSNACOLN, DSNAPRKY, DSNAFNKY .......
(in response to Hessel Rus)
These programs are used by stored procedures SYSIBM.SQLCOLPRIVILEGES,SQLCOLUMNS, SQLFOREIGNKEYS ...
which extract information from the catalog for some DRDA applications like Visual Explain V8, ODBC Drivers or something like that.
They use temporary tables to store intermediate resultsets to be returned to the caller application.

Mauro Moschelli
SanPaoloIMI S.p.A.

-> -----Original Message-----
-> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
-> Behalf Of Peter, Georg
-> Sent: Wednesday, December 22, 2004 12:14 PM
-> To: [login to unmask email]
-> Subject: programs like DSNACOLN, DSNAPRKY, DSNAFNKY .......
->
->
-> Collegues,
->
-> while monitoring our DB2 OS/390 V6 subsystem, I saw some
-> programs like
-> DSNACOLN, DSNAPRKY, DSNAFNKY and DSNATBLS. These programs
-> are unknown for
-> me.....
->
-> These programms accessed tables, e.g. SYSIBM . SQTCOLUMNS, SYSIBM .
-> SQTPRIMARYKEYS, SYSIBM . SQTFOREIGNKEYS and SYSIBM .
-> SQTTABLES have the
-> TYPE = G (temporary tables).
->
-> It may be a stupid question, but: Does anyone know what
-> these programs are
-> doing ? And what is the reason for these temporary tables ?
->
-> Any comments, thoughts, experiences are highly appreciated.
->
-> Thanks in advance.
->
-> With kind regards - mit freundlichen Gruessen,
-> Georg H. Peter c/o
-> -------------------------------------------------------------------
-> Datenzentrale Baden-Wuerttemberg
-> Software Development & Technology Center
-> Knowledge Center Database Systems
-> Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
-> e:mail [login to unmask email]
-> Phone 0049-711-8108-271
-> PC-Fax 004971189696071
-> Internet (only in german language):http://www.dzbw.de
-> -------------------------------------------------------------
-> ---------
-> "Every action is a p o s i t i v e action, even if it has
-> a negative
-> result."
->
-> -------------------------------------------------------------
-> --------------------
-> Welcome to the IDUG DB2-L list. To unsubscribe, go to the
-> archives and home page at
http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Il contenuto e gli allegati di questo messaggio sono strettamente
confidenziali, e ne sono vietati la diffusione e l'uso non autorizzato.

Le opinioni ivi eventualmente espresse sono quelle dell'autore: di
conseguenza il messaggio non costituisce impegno contrattuale tra
Sanpaolo IMI ed il destinatario, e la banca non assume alcuna
responsabilita' riguardo ai contenuti del testo e dei relativi allegati,
ne' per eventuali intercettazioni, modifiche o danneggiamenti.

Qualora il presente messaggio Le fosse pervenuto per errore, Le saremmo
grati se lo distruggesse e, via e-mail, ce ne comunicasse l' errata
ricezione all'indirizzo [login to unmask email]


This e-mail (and any attachment(s)) is strictly confidential and for use
only by intended recipient(s). Any opinions therein expressed are those
of the author. Therefore its content doesn't represent any commitment
between Sanpaolo IMI and the recipient(s) and no liability or
responsibility is accepted by Sanpaolo IMI for the above mentioned
content.

Sanpaolo IMI S.p.A. is a Bank authorised by Banca d'Italia; Sanpaolo IMI
S.p.A., London Branch, is regulated by the Financial Services Authority
for the conduct of investment business in the UK.

If you are not an intended recipient(s), please notify
[login to unmask email] promptly and destroy this message.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm