on 10-22-2013 11:57 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.