on 12-29-2015 6:19 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks All...but still unable to find exact solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
i used DBBC checkdb command ...but unfortunately i had to stop it in middle...due to time consumption .
could it make any impact.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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[
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>>>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.
or
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
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
in
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.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
SS
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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??.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I still find it difficult to relate consistency check and backup image size relationship.
Anyway, go through below mentioned sap note
Regards,
Prithviraj.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.