Skip to Content
avatar image
Former Member

"RUNSTAT and REORGCHK for single table" job is failing

Hi Gurus,

In our production system, "RUNSTAT and REORGCHK for single table" job is failing from last 6 months. Earlier it was running fine. Help help me to resolve this issue. We have DB2 database for this system.

Please find the job log:


Job log overview for job:    ZDBA_RUN_DBSTATC / 16001600

--------------------------------------------------------------------------------------------------------------------------------------------------
|Date      |Time    |Message text                                                                         |Message class|Message no.|Message type|
--------------------------------------------------------------------------------------------------------------------------------------------------
|20.10.2013|16:00:16|Job started                                                                          |     00      |    516    |     S      |
|20.10.2013|16:00:16|Step 001 started                                                                     |     BT      |    611    |     S      |
|20.10.2013|16:00:16|External command: REORGCHK_DBSTAT                                                    |     BT      |    630    |     S      |
|20.10.2013|16:00:16|Related parameter: -n P03 -t DBSTAT -m b                                             |     BT      |    613    |     S      |
|20.10.2013|16:45:38|Ext. prog.: pct_long_lob has been set to 10 percent                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Checking for old entries in db6treorg/db6ireorg ...                      |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Reading table names for runstats ...                                     |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Tables to process: 880 ...                                               |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 1 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 2 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 3 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 4 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 5 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 6 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 7 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 8 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 9 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 10 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 11 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 12 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 13 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 14 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 15 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 16 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 17 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 18 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 19 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 20 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 21 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 22 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 23 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 24 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 25 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 26 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 27 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 28 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 29 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 30 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 31 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 32 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 33 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 34 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 35 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 36 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 37 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 38 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 39 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 40 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 41 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 42 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 43 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 44 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 45 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 46 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 47 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 48 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 49 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 50 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 51 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 52 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 53 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 54 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 55 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 56 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: ERRORMESSAGE: Error -2306 in dmdb6upd.c(692):                            |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: SQL2306N  The table or index "SAPP03.SRRELROLESAKFMFDS" does not         |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: exist.                                                                   |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.:                                                                          |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: table: SAPP03.SRRELROLESAKFMfDs                                          |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 57 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 58 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 59 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 60 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 61 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 62 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 63 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 64 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 65 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 66 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 67 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 68 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 69 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 70 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 71 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 72 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 73 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 74 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 75 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 76 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 77 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 78 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 79 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 80 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 81 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 82 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 83 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 84 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 85 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 86 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 87 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 88 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 89 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 90 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 91 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 92 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 93 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 94 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 95 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 96 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 97 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 98 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 99 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Tables being processed: 880                                              |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Reading N/R/I-flagged table names ...                                    |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Tables to process: 20 ...                                                |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 5 percent ...                                                  |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 10 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 15 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 20 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 25 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 30 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 35 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 40 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 45 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 50 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 55 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 60 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 65 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 70 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 75 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 80 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 85 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 90 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Processed 95 percent ...                                                 |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: Tables being processed: 20                                               |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: External program terminated with exit code 2                             |     BT      |    606    |     S      |
|20.10.2013|16:45:38|Ext. prog.: SAPXPG started on bwp03prd_P03_00, Process ID 18243592, Process Number 84|     BT      |    606    |     S      |
|20.10.2013|16:45:38|External program was cancelled                                                       |     BT      |    614    |     A      |
|20.10.2013|16:45:38|Job cancelled                                                                        |     00      |    518    |     A      |
--------------------------------------------------------------------------------------------------------------------------------------------------


Regards,
Amit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 22, 2013 at 11:25 AM

    Hi Amit,

    Hav eyou checked about this mention error

    The table or index "SAPP03.SRRELROLESAKFMFDS" does not         |     BT      |    606    |     S      |

    please check this in your system.

    also please find the sap note

    860724  - DB6: Configuration of the planning calendar for AutoRunstats

    BR

    Atul

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2013 at 11:14 AM

    Hi Amit,

    If you are using 702,please follow the note below.

    Note 1456402 - DB6: DBA Cockpit Corrections for SAP Basis 7.02/7.30/7.31

    This will help.

    BR,

    Prabhakar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 13, 2013 at 03:36 AM

    Hi Prabhakar,

      I am still facing the same issue. My SAP BW version is 7.01. Hence, those two notes are not applicable to me.

    @ Atul, Yes that table doesnt exist in our database. Please guide me how to proceed from here now.

    Thanks in advance!!

    Regards,

    Amit Mishra

    Add comment
    10|10000 characters needed characters exceeded