check your database

All those commands that we don't really use very often, but that we should ! Documented or not, they worth it !
thkim81

Re: check your database

Post by thkim81 »

(1)kmccs_a> checkdb
Data base checking in progress ...
/................ERROR 4351 : DATA INCONSISTENCY, Table ENTITY, entity=0 invalid cdt
ERROR 4351 : DATA INCONSISTENCY, Table ENTITY, entity=1 invalid cdt
...................../

Is this ok ?

I indicated incvisu below error

21/02/12 17:16:11 000001S|---/--/-/---|=2:2651=SQL err during a FETCH: appli ACCOUNTING table TABJUSTIF err 0

this error is major error ..

How do I check db part ?
vad
Alcatel Unleashed Certified Guru
Alcatel Unleashed Certified Guru
Posts: 3852
Joined: 23 Sep 2004 06:47

Re: check your database

Post by vad »

Checkdb - check you database, on MAIN cpu!
Incident - from stand-by cpu - run checkdb on stand-by. Or better - run mastercopy.
thkim81

Re: check your database

Post by thkim81 »

thanks vad

Today I check active and standby oxe server.

so yesterday error didn't found. it seems that delete.

today is below..

(1)kmccs_b> checkdb
Data base checking in progress ...
/................ERROR 4351 : DATA INCONSISTENCY, Table ENTITY, entity=0 invalid cdt
ERROR 4351 : DATA INCONSISTENCY, Table ENTITY, entity=1 invalid cdt
...................../

this logs are indicated active and standby

is that OK?

I think this log about entity.. That's right?
User avatar
murraya
Alcatel Unleashed Certified Guru
Alcatel Unleashed Certified Guru
Posts: 900
Joined: 16 Oct 2007 02:35

Re: check your database

Post by murraya »

hi, those errors are stating that entity 0 and 1 have either missing or incorrect numbers in the call distrubition tables.
to stop them you will need to fill in the Day, Night, Mode 1, Mode 2 and overflow fields.
Best Regards
Murray

ACSE 10.0 corporate
ACSE 6.x IPT data
User avatar
tot3nkopf
Alcatel Unleashed Certified Guru
Alcatel Unleashed Certified Guru
Posts: 4058
Joined: 02 Feb 2006 10:41
Location: Germany & Romania
Contact:

Re: check your database

Post by tot3nkopf »

I think he has also databases not synchro between CPU's. He has another post with this. I suggested like vad did to rebiold netadmin and do a mastercopy.
Post Reply

Return to “Usefull commands”