Question Re: Database consistency check in Technology Q&A

Database consistency check

former_member262203 — Tue, 29 Dec 2015 06:19:03 GMT

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

Re: Database consistency check

Former Member — Tue, 29 Dec 2015 08:56:39 GMT

Hi Sharad,

I have zero knowledge on SYBASE database, but than why are you performing consistency check?

Consistency operation is only when you perform refresh activity or you find any database corruption.

and yes this operation is time consuming and consumes lot of resources.

Backup image size with mostly depend upon your database size, for any live system we have insert/update/delete operations performed on database this increases/decreases database size which in return will have effect on your backup image size.

Regards,

Prithviraj.

Re: Database consistency check

former_member262203 — Tue, 29 Dec 2015 09:19:19 GMT

Former Member ..thanks for response
i want to just confirm no data loss made...all of sudden 4 GB cant be reduced over a night...means it decreased by almost 7.8%...isnt it strange??
and i am unable to get output in DB12....
is there anyway to ensure its consistency and integrity.. at SAP Level??.

Re: Database consistency check

Former Member — Tue, 29 Dec 2015 10:03:53 GMT

Hi,

I still find it difficult to relate consistency check and backup image size relationship.

Anyway, go through below mentioned sap note

2226537 - SAP ASE DBCC checks

Regards,

Prithviraj.

Re: Database consistency check

S_Sriram — Tue, 29 Dec 2015 11:10:39 GMT

Hi Sharad.

On your production system have you carry out any database management (Any deletion)? or Everyday have you check the transaction log size? you can check over all the database size using the transaction DB02 space history.

Regards

Re: Database consistency check

former_member262203 — Tue, 29 Dec 2015 12:13:16 GMT

nope i havnt perform any activity ... @S_Sriram
db02 is not showing any change or resize activity....in history
is there any way so i would be able to check if any obj touched...in DB
4GB is a great amount in compressed from ...that is the only worry for me....

Re: Database consistency check

S_Sriram — Tue, 29 Dec 2015 12:30:16 GMT

Could you share you sybase DB, SAP system kernel, SP level version details? and use the transaction code dbacockpit

Re: Database consistency check

former_member262203 — Tue, 29 Dec 2015 13:08:09 GMT

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

Re: Database consistency check

S_Sriram — Tue, 29 Dec 2015 13:15:14 GMT

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

Re: Database consistency check

former_member262203 — Tue, 29 Dec 2015 13:23:29 GMT

>>>There is nothing in error ...given message was when i select checked Informational Filed

>>>>>two dumps are there--

1----

Category ABAP Programming Error

Runtime Errors LOAD_PROGRAM_NOT_FOUND

ABAP Program CL_SWNC_TCOLL_RUNNER==========CP

Application Component BC-CCM-MON

Date and Time 28.12.2015 12:28:59

Short text

Program "RSORA811" not found.

What happened?

There are several possibilities:

Error in the ABAP Application Program

The current ABAP program "CL_SWNC_TCOLL_RUNNER==========CP" had to be

terminated because it has

come across a statement that unfortunately cannot be executed.

Error in the SAP kernel.

The current ABAP "CL_SWNC_TCOLL_RUNNER==========CP" program had to be

terminated because the

ABAP processor detected an internal system error.

2---

Category ABAP Programming Error

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

CX_SY_OPEN_SQL_DB

ABAP Program SAPLFI_INT

Application Component FI

Date and Time 28.12.2015 15:45:35
-----------------------------------

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

procedure "FI_INTITIT_WRITE" "(FUNCTION)", nor was it propagated by a RAISING

clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

If you use an ABAP/4 Open SQL array insert to insert a record in

the database and that record already exists with the same key,

this results in a termination.

(With an ABAP/4 Open SQL single record insert in the same error

situation, processing does not terminate, but SY-SUBRC is set to 4.)

Re: Database consistency check

S_Sriram — Tue, 29 Dec 2015 13:42:23 GMT

Hi Sharad.

1. I think after installation have you schedule the SAP Stand jobs? Kindly refer the SAP KBA

2231932 - How to schedule SAP_SOAP_RUNTIME_MANAGEMENT standard background job

2. Every day your are getting dump in SAP_COLLECTOR_FOR_PERFMONITOR Kindly implement the SAP Note to avoid the dumps and Standard job getting cancelled

1841778 - LOAD_PROGRAM_NOT_FOUND in RSCOLL00

Regards

Re: Database consistency check

former_member262203 — Wed, 30 Dec 2015 13:53:45 GMT

Thanks a lot @sriram..
i would really appricate if i could get any way ...how to ensure DB consistency in Sybase..as the core issue ..i raised...Plz help[

Re: Database consistency check

S_Sriram — Wed, 30 Dec 2015 19:19:05 GMT

Hi Sharad.

First do the DB check as mention the SAP Note by Prithviraj. check the any error in the DB?

Re: Database consistency check

former_member262203 — Fri, 08 Jan 2016 10:50:59 GMT

i used DBBC checkdb command ...but unfortunately i had to stop it in middle...due to time consumption .
could it make any impact.

Re: Database consistency check

Former Member — Tue, 12 Jan 2016 20:19:10 GMT

Hello Sharad Kumar:

Cancelling DBCC check should not impact your DB consistency. While executing your DB checks you have to be patient as it is a time consuming process as everyone here has already mentioned.

thanks.

Re: Database consistency check

former_member262203 — Thu, 14 Jan 2016 12:10:50 GMT

Thanks Mandeep...but my doubt is still not resolved...how could a bckup size of DB reduced suddenly...dbcc is the way to check consistency ...okay..if i execute it again it gonna take a load of time....isnt there nay other way to check DB consistency in better way and could find what happened exactly....

Thanx in advance

Re: Database consistency check

Former Member — Thu, 14 Jan 2016 12:40:08 GMT

Hi Sharad,

I believe you're over working on this.

As far as I know we cannot control over Backup image size, it will be what it can be depending on what all is backup and what DB size is.

Anyway, you can work towards compressing the backup image and other things..

1750510 - FAQ: Sybase ASE 15.7 Compression

2226574 - Too many dump files are created after backup in IQ.

Regards,

Prithviraj.

Re: Database consistency check

former_member262203 — Fri, 15 Jan 2016 06:55:05 GMT

agreed ..obviously back-up size depends on DB size ...thats why i am scared ...what happened to DB so its .dmp file reduced to its size by almost upto 3 GB..and its compressed...so in case of data loss think how much data we ve lost..

although more than 3 weeks have been passed ...restored it on TEST ...didnt get any complaint from Functional guys or from users..what I have done is only incomplete DBCC ....so i want o clear my doubt of data loss

Re: Database consistency check

Former Member — Sat, 16 Jan 2016 06:54:28 GMT

Hi,

May be this thread can help..

unable to take backup in sybase with dump command | SCN

hope this helps clear doubt

best regards,

Manjunath

Re: Database consistency check

Former Member — Sat, 16 Jan 2016 12:59:38 GMT

Hi Sharad,

3GB data loss... what made you think that data is lost here? Just because the backup size has reduced to a size does not (or will never mean) there is data loss.

If backup is running with same set of tables/tablespace (or entire database) and is completing successfully, you need not worry about size.

Regards,

Prithviraj