RE: [SPAM] - Package information - Number of numbers in MIME From exceeds maximum threshold

RE: [SPAM] - Package information - Number of numbers in MIME From exceeds maximum threshold

 

  

Pedro,

If you have the bind files using which the package was created, you may use the command db2bfd to list out the SQLs in the bind file/package.

Usage: db2bfd [ [-b] [-h] [-s] [-v] ] <filespec>

Where: <filespec> is a V7 or V8 bind file

Options: -b = display bind file header
-h = display this information
-s = display SQL statements
-v = display host variable declarations

Use it with the -s option.

Ravi


-----Original Message-----
From: Pedro Miguel Gonçalves [mailto:db2udbdba-ezmlmshield-x30916053.[Email address protected]
Sent: Thursday, February 24, 2005 5:14 PM
To: LazyDBA Discussion
Subject: FW: [SPAM] - Package information - Number of numbers in MIME From exceeds maximum threshold



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



---------------------------------------------------------------------
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