Database consistency check

[#1]

Dear experts,

My Env is- Aix+Sybase. Backup device is tape. i need to take back-up daily so there is scheduler is set for the same.take backup of transactions hourly.

now issue is that  previously the size of my back-up .dmp(PRD sys) file was approx 55GB but all of sudden it reduced to 52 gb from last five days so i was scared if there would any data-loss..for that i just restored it on Test server and run dbcc checkdb.it took too much time i had to hault that after 6 hrs.
Both system is functioning properly no compalints from user and functional consultanats till date.

is there anyway to check DB intergrity..easily
Pl help

[former_member262203]

hello Sriram..its ASE 15.7
BASIS 731/6 Kernel rel-720
i ve already used DBACOCKPIT not showing an error...but when i selected informational checkbox (last-one)  it showed..

Time	Message Type	Severity	Server Process ID	Error Message	Error Number
42353.87464	Information	0	11	Begin processing to generate RSA keypair.	110,299
42353.87464	Information	0	11	Completed processing to generate RSA keypair.	110,300
42353.87464	Information	0	11	Begin processing to generate RSA keypair.	110,299
42353.87464	Information	0	11	Completed processing to generate RSA keypair.	110,300
42354.46243	Information	0	93	Cannot send, host process disconnected: eccc 16908308 suid: 6	120,191
42354.55458	Information	0	84	Cannot send, host process disconnected: eccc 40435728 suid: 6	120,191
42354.87534	Information	0	11	Begin processing to generate RSA keypair.	110,299
42354.87535	Information	0	11	Completed processing to generate RSA keypair.	110,300
42354.87535	Information	0	11	Begin processing to generate RSA keypair.	110,299
42354.87535	Information	0	11	Completed processing to generate RSA keypair.	110,300
42355.7101	Information	0	72	Cannot send, host process disconnected: eccc 40435732 suid: 6	120,191
42355.87656	Information	0	11	Begin processing to generate RSA keypair.	110,299
42355.87656	Information	0	11	Completed processing to generate RSA keypair.	110,300
42355.87656	Information	0	11	Begin processing to generate RSA keypair.	110,299
42355.87656	Information	0	11	Completed processing to generate RSA keypair.	110,300
42356.74942	Information	0	183	Cannot send, host process disconnected: eccc 44368094 suid: 6	120,191
42356.7717	Information	0	88	Cannot send, host process disconnected: eccc 44171332 suid: 6	120,191
42356.77295	Information	0	43	Cannot send, host process disconnected: eccc 40435734 suid: 6	120,191
42356.773	Information	0	227	Cannot send, host process disconnected: eccc 35782774 suid: 6	120,191
42356.87765	Information	0	11	Begin processing to generate RSA keypair.	110,299
42356.87765	Information	0	11	Completed processing to generate RSA keypair.	110,300
42356.87765	Information	0	11	Begin processing to generate RSA keypair.	110,299
42356.87765	Information	0	11	Completed processing to generate RSA keypair.	110,300
42357.62418	Information	0	121	Cannot send, host process disconnected: eccc 25952488 suid: 6	120,191
42357.63485	Information	0	55	Cannot send, host process disconnected: eccc 41418802 suid: 6	120,191
42357.87898	Information	0	11	Begin processing to generate RSA keypair.	110,299
42357.87899	Information	0	11	Completed processing to generate RSA keypair.	110,300
42357.87899	Information	0	11	Begin processing to generate RSA keypair.	110,299
42357.87899	Information	0	11	Completed processing to generate RSA keypair.	110,300
42358.08336	Information	0	45	DBCC TRACEON 11906, SPID 45	180,006
42358.87973	Information	0	11	Begin processing to generate RSA keypair.	110,299
42358.87973	Information	0	11	Completed processing to generate RSA keypair.	110,300
42358.87973	Information	0	11	Begin processing to generate RSA keypair.	110,299
42358.87973	Information	0	11	Completed processing to generate RSA keypair.	110,300
42359.45233	Status information	10	35	Cannot send, host process disconnected: eccc 22544446 suid: 4	15,904
42359.45233	Status information	10	35	The total number of deleted rows in partition 'BANK_PP_STEPDATA_1787970515' (partition ID 1787970...	15,099
42359.45233	Status information	10	35	The total number of pages in partition 'BANK_PP_STEPDATA_1787970515' (partition ID 1787970515) wi...	15,900
42359.45233	Status information	10	35	The total number of pages in partition 'BANK_PP_STEPDATA_1787970515' (partition ID 1787970515) wi...	15,901
42359.45233	Status information	10	35		3,640
42359.45233	Status information	10	35	The total number of data pages in this table is 1.	2,579
42359.45233	Status information	10	35	The total number of empty pages (with all deleted rows) in this table is 1.	12,931
42359.45233	Status information	10	35	The total number of pages with more than 50 percent insert free space is 1.	15,076
42359.45233	Status information	10	35	Table has 0 data rows.	7,929
42359.45234	Status information	10	35	Checking table 'A117' (object ID 1851970743): Logical page size is 16384 bytes.	15,045
42359.45234	Status information	10	35		3,640
42359.45234	Status information	10	35	Checking partition 'A117_1851970743' (partition ID 1851970743) of table 'A117'. The logical page ...	15,042
42359.48388	Information	0	224	Cannot send, host process disconnected: eccc 16908312 suid: 6	120,191
42359.88067	Information	0	11	Begin processing to generate RSA keypair.	110,299
42359.88067	Information	0	11	Completed processing to generate RSA keypair.	110,300
42359.88067	Information	0	11	Begin processing to generate RSA keypair.	110,299
42359.88067	Information	0	11	Completed processing to generate RSA keypair.	110,300
42360.88162	Information	0	11	Begin processing to generate RSA keypair.	110,299
42360.88162	Information	0	11	Completed processing to generate RSA keypair.	110,300
42360.88162	Information	0	11	Begin processing to generate RSA keypair.	110,299
42360.88162	Information	0	11	Completed processing to generate RSA keypair.	110,300
42361.88233	Information	0	11	Begin processing to generate RSA keypair.	110,299
42361.88233	Information	0	11	Completed processing to generate RSA keypair.	110,300
42361.88233	Information	0	11	Begin processing to generate RSA keypair.	110,299
42361.88233	Information	0	11	Completed processing to generate RSA keypair.	110,300
42362.66735	Information	0	240	Cannot send, host process disconnected: eccc 28442732 suid: 6	120,191
42362.88347	Information	0	11	Begin processing to generate RSA keypair.	110,299
42362.88347	Information	0	11	Completed processing to generate RSA keypair.	110,300
42362.88347	Information	0	11	Begin processing to generate RSA keypair.	110,299
42362.88347	Information	0	11	Completed processing to generate RSA keypair.	110,300
42363.88436	Information	0	11	Begin processing to generate RSA keypair.	110,299
42363.88436	Information	0	11	Completed processing to generate RSA keypair.	110,300
42363.88436	Information	0	11	Begin processing to generate RSA keypair.	110,299
42363.88438	Information	0	11	Completed processing to generate RSA keypair.	110,300
42364.67215	Information	0	174	Cannot send, host process disconnected: eccc 37748868 suid: 6	120,191
42364.88544	Information	0	11	Begin processing to generate RSA keypair.	110,299
42364.88545	Information	0	11	Completed processing to generate RSA keypair.	110,300
42364.88545	Information	0	11	Begin processing to generate RSA keypair.	110,299
42364.88545	Information	0	11	Completed processing to generate RSA keypair.	110,300
42365.08338	Information	0	131	DBCC TRACEON 11906, SPID 131	180,006
42365.88659	Information	0	11	Begin processing to generate RSA keypair.	110,299
42365.8866	Information	0	11	Completed processing to generate RSA keypair.	110,300
42365.8866	Information	0	11	Begin processing to generate RSA keypair.	110,299
42365.8866	Information	0	11	Completed processing to generate RSA keypair.	110,300

Message was edited by: Sharad Kumar

[S_Sriram]

Hi

1.  Are you getting any dumps in transaction ST22? If it is yes, Could you share the dump

2. Check this SAP Note for DBACOCKPIT error

1619967 - SYB: DBA Cockpit Correction Collection SAP Basis 7.31

Regards

SS