Thanks for the information Praveen but I still have a problem, I think the sysibm.syspackdep is not necessary because the explain table gives me the table that the package accesses, and the action performed in it, but it doesn´t give the fields and actions on those fields made by the package.
Please help me.
-----Mensagem original-----
De: Praveen Chengalathu [mailto:db2udbdba-ezmlmshield-x19979297.[Email address protected]
Enviada: quinta-feira, 24 de Fevereiro de 2005 11:30
Para: LazyDBA Discussion
Assunto: RE: [SPAM] - Package information - Number of numbers in MIME From exceeds maximum threshold
The dependent tables can be found in SYSIBM.SYSPACKDEP and the actions can be found in the EXPLAIN Tables.
-----Original Message-----
From: Pedro Miguel Gonçalves
[mailto:db2udbdba-ezmlmshield-x40881113.[Email address protected]
Sent: 24 February 2005 11:25
To: LazyDBA Discussion
Subject: [SPAM] - Package information - Number of numbers in MIME From exceeds maximum threshold
Hi fellow DBA's,
I have a question,
In DB2 v.7 for OS/390 is there a system table that gives me the information about the following:
To what tables a package goes and what actions does it make on those tables (like insert update or delete) and in what fields.
Thanks in advance.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page