ca.portal.admin

Re:Debugging database procedures

Discussion created by ca.portal.admin on Mar 29, 2007
What techniques are available for debugging database procedures? I am
talking here about the kind that are tied to a record via the schema
description.

We are getting D003 errors when trying to use DEBUG. Is DEBUG supposed
to work with database procedures?

My personal favorite technique for debugging online programs is
""displaying"" to the log via the WTL command. But you are not supposed
to make DML calls from a database procedure.

Any suggestions would be most welcome.

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Debugging database procedures
"kay - I never considered a #WTL a DML command, but rather a DC command - I
think you are safe! (in the same vein that ""write printer"" command causes
database activity, but I would also consider that a DC, not DML, command)




This is Chris Hoelscher and I approved this message!

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com






""Rozeboom, Kay
[DAS]""
<KAY.ROZEBOOM@IOW To
A.GOV> IDMSVENDOR-L@LISTSERV.IUASSN.COM
Sent by: IDMS cc
3rd-party
providers forum Subject
<IDMSVENDOR-L@LIS [IDMSVENDOR-L] Debugging database
TSERV.IUASSN.COM> procedures


03/29/2007 08:56
AM


Please respond to
IDMS Public
Discussion Forum
<IDMS-L@LISTSERV.
IUASSN.COM>






What techniques are available for debugging database procedures? I am
talking here about the kind that are tied to a record via the schema
description.

We are getting D003 errors when trying to use DEBUG. Is DEBUG supposed
to work with database procedures?

My personal favorite technique for debugging online programs is
""displaying"" to the log via the WTL command. But you are not supposed
to make DML calls from a database procedure.

Any suggestions would be most welcome.

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov


The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Debugging database procedures
"My personal favorite is writing trace info to ISA. In the program
definition you can define an initial storage allocation. On entry, an
application program already has register 11 primed with the starting
address of the ISA. It can then write any info into memory it wants.
On abend, the storage will be in the snap. Stuff an eye catch at the
beginning and you can search memory any time for the eyecatch and look
at the content. The ISA is reentrant, so there will be one for every
task that uses the program. It could be a lot of storage, basically the
max being a factor of what your maxconcurrent tasks or maxtasks are.
For erus, potentially a factor of maxerus. But on a test system that
would be entirely minimal.

Lutz Petzold



This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Debugging database procedures
"Kay,

Not really used DEBUG but I an sure it only works for user mode
programms and database procedures run in system mode.

When it says no DML it really means no database commands. Before I say
any more I what to double check that the procedure is written in
assembler. Is this the case?

Pete

Outcomes