cancel
Showing results for 
Search instead for 
Did you mean: 

"RUNSTAT and REORGCHK for single table" job is failing

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

AtulKumarJain
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Amit,

Run the runstat and reorg from Solman System  if it is CUA, which completed successfully.

Also chcek : Note 1839880 - DB6: SQL0150N During DCF Setup

BR,

Prabhakar