Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dbbackup Causing Lost Record

5 posts in General Discussion Last posting was on 2005-03-03 13:53:21.0Z
Arias Tanti Posted on 2005-03-02 02:52:29.0Z
Reply-To: "Arias Tanti" <atantih@yahoo.com>
From: "Arias Tanti" <atantih@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: dbbackup Causing Lost Record
Lines: 42
Organization: XLink
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 202.155.117.37
Message-ID: <42252a69@forums-2-dub>
X-Original-Trace: 1 Mar 2005 18:52:25 -0800, 202.155.117.37
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 1 Mar 2005 18:52:26 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 1 Mar 2005 18:52:29 -0800
X-Trace: forums-1-dub 1109731949 10.22.108.75 (1 Mar 2005 18:52:29 -0800)
X-Original-Trace: 1 Mar 2005 18:52:29 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4174
Article PK: 8053

I'm doing backup procedures using Sybase ASA ver8.02 patch 4513. These are
the steps.

1. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -xo

2. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y [directory]

3. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y -t -x [directory]

4. dbtran -y [lognamefile.log]

5. dbisql -onerror continue -nogui -q -c "ENG=xwh;UID=x;PWD=x;LINKS=tcpip"
read [sqlnamefile.sql]

And these are the steps of the syntax.

1. insert into [table1name]

2. insert into [table2name]

3. insert into [table3name]

4. insert into [table2name]

5. update [table3name]

6. update [table1name]

7. update [table1name]

I've found some records missing. All of them tended to be located in the
transition between one backup log file and the next one.

Please inform me the explanations to overcome this problem.



Regards,

Arias Tanti Hapsari (atantih@yahoo.com)


Chris Keating (iAnywhere Solutions) Posted on 2005-03-02 05:17:11.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <42252a69@forums-2-dub>
Subject: Re: dbbackup Causing Lost Record
Lines: 72
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vpn-dub-085.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-085.sybase.com
Message-ID: <42254c57$1@forums-1-dub>
Date: 1 Mar 2005 21:17:11 -0800
X-Trace: forums-1-dub 1109740631 10.22.120.85 (1 Mar 2005 21:17:11 -0800)
X-Original-Trace: 1 Mar 2005 21:17:11 -0800, vpn-dub-085.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4177
Article PK: 8055

Please do not crosspost.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

*****************************************************************************

"Arias Tanti" <atantih@yahoo.com> wrote in message
news:42252a69@forums-2-dub...
> I'm doing backup procedures using Sybase ASA ver8.02 patch 4513. These are
> the steps.
>
> 1. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -xo
>
> 2. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y [directory]
>
> 3. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y -t -x [directory]
>
> 4. dbtran -y [lognamefile.log]
>
> 5. dbisql -onerror continue -nogui -q -c "ENG=xwh;UID=x;PWD=x;LINKS=tcpip"
> read [sqlnamefile.sql]
>
> And these are the steps of the syntax.
>
> 1. insert into [table1name]
>
> 2. insert into [table2name]
>
> 3. insert into [table3name]
>
> 4. insert into [table2name]
>
> 5. update [table3name]
>
> 6. update [table1name]
>
> 7. update [table1name]
>
> I've found some records missing. All of them tended to be located in the
> transition between one backup log file and the next one.
>
> Please inform me the explanations to overcome this problem.
>
>
>
> Regards,
>
> Arias Tanti Hapsari (atantih@yahoo.com)
>
>


Breck Carter [TeamSybase] Posted on 2005-03-02 13:03:51.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: dbbackup Causing Lost Record
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <bceb215no3m87f3cbp5nb5e4614j7tmf67@4ax.com>
References: <42252a69@forums-2-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 2 Mar 2005 05:03:51 -0800
X-Trace: forums-1-dub 1109768631 64.7.134.118 (2 Mar 2005 05:03:51 -0800)
X-Original-Trace: 2 Mar 2005 05:03:51 -0800, bcarter.sentex.ca
Lines: 56
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4178
Article PK: 8056

I don't exactly understand what you are trying to demonstrate, but if
you want to see uncommitted transactions in the dbtran output, try
using the -a option.

Breck

On 1 Mar 2005 18:52:29 -0800, "Arias Tanti" <atantih@yahoo.com> wrote:

>I'm doing backup procedures using Sybase ASA ver8.02 patch 4513. These are
>the steps.
>
>1. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -xo
>
>2. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y [directory]
>
>3. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y -t -x [directory]
>
>4. dbtran -y [lognamefile.log]
>
>5. dbisql -onerror continue -nogui -q -c "ENG=xwh;UID=x;PWD=x;LINKS=tcpip"
>read [sqlnamefile.sql]
>
>And these are the steps of the syntax.
>
>1. insert into [table1name]
>
>2. insert into [table2name]
>
>3. insert into [table3name]
>
>4. insert into [table2name]
>
>5. update [table3name]
>
>6. update [table1name]
>
>7. update [table1name]
>
>I've found some records missing. All of them tended to be located in the
>transition between one backup log file and the next one.
>
>Please inform me the explanations to overcome this problem.
>
>
>
>Regards,
>
>Arias Tanti Hapsari (atantih@yahoo.com)
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


Arias Tanti Posted on 2005-03-03 02:34:48.0Z
Reply-To: "Arias Tanti" <atantih@yahoo.com>
From: "Arias Tanti" <atantih@yahoo.com>
Newsgroups: ianywhere.public.general
References: <42252a69@forums-2-dub> <bceb215no3m87f3cbp5nb5e4614j7tmf67@4ax.com>
Subject: Re: dbbackup Causing Lost Record
Lines: 70
Organization: XLink
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 202.155.117.37
X-Original-NNTP-Posting-Host: 202.155.117.37
Message-ID: <422677c8@forums-1-dub>
Date: 2 Mar 2005 18:34:48 -0800
X-Trace: forums-1-dub 1109817288 202.155.117.37 (2 Mar 2005 18:34:48 -0800)
X-Original-Trace: 2 Mar 2005 18:34:48 -0800, 202.155.117.37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4191
Article PK: 8068

No ... I have also used -a option, but still that RECORD IS MISSING !!!!
In the .sql file, I saw that the transaction is being ROLLBACK instead of
being COMMIT. But I don't know what's wrong with that. Because all other
transactions are OK. Suddenly one or two records are MISSING.
Please help me with this.

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:bceb215no3m87f3cbp5nb5e4614j7tmf67@4ax.com...
> I don't exactly understand what you are trying to demonstrate, but if
> you want to see uncommitted transactions in the dbtran output, try
> using the -a option.
>
> Breck
>
> On 1 Mar 2005 18:52:29 -0800, "Arias Tanti" <atantih@yahoo.com> wrote:
>
> >I'm doing backup procedures using Sybase ASA ver8.02 patch 4513. These
are
> >the steps.
> >
> >1. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -xo
> >
> >2. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y [directory]
> >
> >3. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y -t -x [directory]
> >
> >4. dbtran -y [lognamefile.log]
> >
> >5. dbisql -onerror continue -nogui -q -c
"ENG=xwh;UID=x;PWD=x;LINKS=tcpip"
> >read [sqlnamefile.sql]
> >
> >And these are the steps of the syntax.
> >
> >1. insert into [table1name]
> >
> >2. insert into [table2name]
> >
> >3. insert into [table3name]
> >
> >4. insert into [table2name]
> >
> >5. update [table3name]
> >
> >6. update [table1name]
> >
> >7. update [table1name]
> >
> >I've found some records missing. All of them tended to be located in the
> >transition between one backup log file and the next one.
> >
> >Please inform me the explanations to overcome this problem.
> >
> >
> >
> >Regards,
> >
> >Arias Tanti Hapsari (atantih@yahoo.com)
> >
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com


Chris Keating (iAnywhere Solutions) Posted on 2005-03-03 13:53:21.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <42252a69@forums-2-dub> <bceb215no3m87f3cbp5nb5e4614j7tmf67@4ax.com> <422677c8@forums-1-dub>
Subject: Re: dbbackup Causing Lost Record
Lines: 85
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <422716cd@forums-2-dub>
X-Original-Trace: 3 Mar 2005 05:53:17 -0800, keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Mar 2005 05:53:18 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Mar 2005 05:53:21 -0800
X-Trace: forums-1-dub 1109858001 10.22.108.75 (3 Mar 2005 05:53:21 -0800)
X-Original-Trace: 3 Mar 2005 05:53:21 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4193
Article PK: 8071

Please help us to help you. You crossposted to the
sybase.pulbic.sqlanywhere.general group and I responded with questions and a
request for a better 'steps to reproduce' with no response. The behaviour
that you are describing is inconsistent with the expected behaviour but it
is impossible to determine how you get there based on the information
provided which placed the backup sequence outside the DML sequence.

Please use the sqlanywhere.general group to continue this thread.

"Arias Tanti" <atantih@yahoo.com> wrote in message
news:422677c8@forums-1-dub...
> No ... I have also used -a option, but still that RECORD IS MISSING !!!!
> In the .sql file, I saw that the transaction is being ROLLBACK instead of
> being COMMIT. But I don't know what's wrong with that. Because all other
> transactions are OK. Suddenly one or two records are MISSING.
> Please help me with this.
>
>
> "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> message news:bceb215no3m87f3cbp5nb5e4614j7tmf67@4ax.com...
>> I don't exactly understand what you are trying to demonstrate, but if
>> you want to see uncommitted transactions in the dbtran output, try
>> using the -a option.
>>
>> Breck
>>
>> On 1 Mar 2005 18:52:29 -0800, "Arias Tanti" <atantih@yahoo.com> wrote:
>>
>> >I'm doing backup procedures using Sybase ASA ver8.02 patch 4513. These
> are
>> >the steps.
>> >
>> >1. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -xo
>> >
>> >2. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y [directory]
>> >
>> >3. dbbackup -c "ENG=x;UID=x;PWD=x;LINKS=tcpip" -y -t -x [directory]
>> >
>> >4. dbtran -y [lognamefile.log]
>> >
>> >5. dbisql -onerror continue -nogui -q -c
> "ENG=xwh;UID=x;PWD=x;LINKS=tcpip"
>> >read [sqlnamefile.sql]
>> >
>> >And these are the steps of the syntax.
>> >
>> >1. insert into [table1name]
>> >
>> >2. insert into [table2name]
>> >
>> >3. insert into [table3name]
>> >
>> >4. insert into [table2name]
>> >
>> >5. update [table3name]
>> >
>> >6. update [table1name]
>> >
>> >7. update [table1name]
>> >
>> >I've found some records missing. All of them tended to be located in the
>> >transition between one backup log file and the next one.
>> >
>> >Please inform me the explanations to overcome this problem.
>> >
>> >
>> >
>> >Regards,
>> >
>> >Arias Tanti Hapsari (atantih@yahoo.com)
>> >
>>
>> --
>> SQL Anywhere Studio 9 Developer's Guide
>> Buy the book:
> http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
>> bcarter@risingroad.com
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com
>
>