別管它或者發(fā)CSR，以下供參考!

Condition:
1. Enter command into EX side :
DBTSP:TAB=TABLES,FCERROR=YES,PROJ=NAME&BLKREF&TABREF&SEARINX&PKINX&VERFIED&FKREL&FCERROR;

Must reply with only table ESSVPPMS:

Result:
DATABASE TABLE

BLOCKTAB TABLE WRAPPED
DBTAB3TABLESYES

TROWNONAME BLKREFTABREF SEARINX PKINXVERFIED FKREL
23 ESSVPPMS253471NOTVER NOTVERVERVER
FCERROR
YES

END

2. Ensure no other database activity in progress.
沒有其它DBTRI指令在用

3. A1 Alarm: DATABASE INCONSISTENCY is present in the alarm list

4. Confirmation that Dbase corruption does not exist:

Print the entire ESSVPPMS table and import into EXCEL.
Create a new column called OFFSET which EXCEL will calculate for all rows:where OFFSET = PMROW - LOGPHR
Sort entire spreadsheet on ALGID then ASTID
Manually search through the spreadsheet. For each ALGID & ASTID case (combination), the OFFSET must be the same.
將table ESSVPPMS打印出來并導(dǎo)到EXCEL中，按ALGID＋ASTID排序，對于同樣的ALGID＋ASTID，其（PMROW－LOGPHR）的差值必須一樣

5. Variable ALGORITHMSTATE (2) in block ASGTB set to PMACT (2) for all routes which have more than 1 phrase defined:

Get all ASGTB type routes:

EXROP:DETY=ASGTB;

eg:
ROUTE DATA

R ROUTE PARAMETERS
SR6020DETY=ASGTB FNC=6020! routep=20
SR6029DETY=ASGTB FNC=6029! routep=29
SR6069DETY=ASGTB FNC=6069! routep=69

END

For each route listed determine routep, print ALGORITHMSTATE value:
Test System；
PRINT V ASGTB 20:2; !must equal 2
PRINT V ASGTB 29:2; !must equal 2
PRINT V ASGTB 69:2; !must equal 2
PRINT V ASGTB 0－:2; !must equal 0 except above 3

所有ASGTB路由對應(yīng)的ALGORITHMSTATE值都必須是2，其它為0

6. Variable TID (318) in block ASGTB must all be the same for all routep found in step 5:

PRINT V ASGTB 20:318;
PRINT V ASGTB 29:318;
PRINT V ASGTB 69:318;
PRINT V ASGTB 0-:318;
End Test；

The value of TID for all routep found in step 6 must be the same eg: H'FF3A, all other pointers should be 0.
所有ASGTB路由對應(yīng)的TID值都必須是一致，如 H‘FF3A， 其它為0

PROCEDURE:
請在話務(wù)低峰時做以下操作：

1. Clear ALGORITHMSTATE & TID in ASGTB:
Test System；
SET V ASGTB 0-:2=0;
SET V ASGTB 0-:318=0;

2. Remove FC error mark in tab TABLES for ESSVPPMS:

DBTRI;
DBTSC:TAB=TABLES,TROWNO=,FCERROR=NO;!where= 23 for table ESSVPPMS printed inconditions step 1
DBTRE:COM;

3. Remove ESSVPPMS row entries in table DBSFCERRORS:
Print DBSFCERRORS table:
DBTSP:TAB=DBSFCERRORS,BLKREF=25347,TABREF=1;!Note all ERREG values, here we got 21 ERREG values ( erreg =0-20 ) in printout log of SGBMSC.

Remove all entries listed:
DBTRI;
DBTSE:TAB=DBSFCERRORS,ERREG=0;
DBTSE:TAB=DBSFCERRORS,ERREG=1;
...
...
DBTSE:TAB=DBSFCERRORS,ERREG=20; until all ERREG values have been entered.
DBTRE:COM;

4. Clear alarm flag in DBDDH, variable CDBINCONSDETECTED:

PRINT V DBDDH 197; ! this will equal 1 !
SET V DBDDH 197=0;

5. Clear alarm from alarm list:

SEND CPALARM REF MISIO2 VIA JBC WITH 0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,H'F301;
End Test；