How are QSQSVCDMP reports read?

Tags:
AS/400
QSQSVCDMP
Like most dumps the column with any pertinent data does not show any error that I can read.


Software/Hardware used:
OS/400
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Post the dump in question and you issue and we will explain it the best we can.
    134,720 pointsBadges:
    report
  • jbapbecker

    I have the same question..exactly :) getting sqldump and I have no idea how to determine whats wrong--the sql dump contains the following

    5770SS1 V7R1M0 100423 17/10/17 17:13:00                    SQL SERVICE DUMP    ALRTS_AUTO/JLTEST    /879685          PAGE        1
    TYPE  PROGRAM/MODULE/CLASS  STATEMENT  MODULE     PROCEDURE/METHOD               ACT NAME   ACT NUMBER       CTL BNDRY           
          QCMD       QSYS            /01C8                                           *DFTACTGRP 0000000000000001 Y                   
          AUTALRT1   DEV                   AUTALRT1   _QRNP_PEP_AUTALRT1             QILE       0000000000000011 Y                   
          AUTALRT1   DEV        0000009300 AUTALRT1   AUTALRT1                       QILE       0000000000000011 N                   
          AUTALRT1   DEV        0000011800 AUTALRT1   GETDAT                         QILE       0000000000000011 N                   
          QSQROUTE   QSYS       0000016325 QSQROUTE   QSQROUTE                       *DFTACTGRP 0000000000000001 Y                   
          QSQRUN3    QSYS       0000040686 QSQOPEN    SQL_OPEN                       *DFTACTGRP 0000000000000001 N                   
          QSQRUN3    QSYS       0000031866 QSQOPEN    DUMPQDT                        *DFTACTGRP 0000000000000001 N                   
          QSQSBAS2   QSYS       0000003081 QSQSVCDMP  SQSVCDMP                       *DFTACTGRP 0000000000000001 N                   

    100 pointsBadges:
    report
  • jbapbecker

    I have to apologise and also say that its the quickest Ive ever worked something out after posting a problem up. Sorry if I disturbed anyone!

    Correct me if Im wrong, but the 000000000000001 meant that the sql was returning a 1 for an error, then tracing it backwards, I seen that it was having issue with QSQROUTE and this was on line 16325 of my rpg compilation..from that I worked out I hadn't prepared a cursor.. Am I right?

    100 pointsBadges:
    report
  • ToddN2000
    Post the code in question that generated the dump if It small enough
    134,720 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: