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.

dbunload

2 posts in General Discussion Last posting was on 2004-01-07 18:38:22.0Z
Eddie Sizemore Posted on 2004-01-06 19:44:32.0Z
From: "Eddie Sizemore" <esizemorenospam@qx.net>
Newsgroups: ianywhere.public.general
Subject: dbunload
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 12-202-145-203.client.insightbb.com
X-Original-NNTP-Posting-Host: 12-202-145-203.client.insightbb.com
Message-ID: <3ffb1020@forums-1-dub>
Date: 6 Jan 2004 11:44:32 -0800
X-Trace: forums-1-dub 1073418272 12.202.145.203 (6 Jan 2004 11:44:32 -0800)
X-Original-Trace: 6 Jan 2004 11:44:32 -0800, 12-202-145-203.client.insightbb.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2250
Article PK: 4455

I am trying to update three version 8.02 dbs to version 9. The dbs
replicate using dbremote and are oem databases. I am using the following
command to update the databases:

dbunload -c "uid=DBA;pwd=SQL;dbf=NLSCons.db" -ar OldLogs

Which according to the help should upgrade my db from ver 8 to 9 and allow
replication to continue.

My first problem is the dbunload utility will gpf at the end of the reload
for one of the dbs. The two other dbs complete the process with no gpf. I
have checked the validity of the dbs before the conversion and after and all
dbs are fine.

Problem #2. During the dbunload process with the -ar switch the log file is
renamed to name.olg and moved to the OldLogs dir. The db will start fine
but when I run dbremote is indicates it can't find the offset in the log
file.

What am I doing wrong or what is the correct procedure to upgrade a db that
is involved in replication?

TIA


Jason Hinsperger Posted on 2004-01-07 18:38:22.0Z
From: "Jason Hinsperger" <NOJason_HinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <3ffb1020@forums-1-dub>
Subject: Re: dbunload
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: hinsperg-pc1.sybase.com
X-Original-NNTP-Posting-Host: hinsperg-pc1.sybase.com
Message-ID: <3ffc521e$1@forums-1-dub>
Date: 7 Jan 2004 10:38:22 -0800
X-Trace: forums-1-dub 1073500702 172.31.143.226 (7 Jan 2004 10:38:22 -0800)
X-Original-Trace: 7 Jan 2004 10:38:22 -0800, hinsperg-pc1.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2256
Article PK: 4459

For 1, it sounds like you have uncovered a problem. Please log a case with
your database either with tech. support or via case express.
For 2, is 'OldLogs' the same transaction log directory you provide when you
run dbremote? It should be, or you should move the .olg file from the
'oldlogs' directory into your dbremote transaction logs directory.

--
Jason Hinsperger
International and Sustaining Engineering
iAnywhere Solutions

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
--

"Eddie Sizemore" <esizemorenospam@qx.net> wrote in message
news:3ffb1020@forums-1-dub...
> I am trying to update three version 8.02 dbs to version 9. The dbs
> replicate using dbremote and are oem databases. I am using the following
> command to update the databases:
>
> dbunload -c "uid=DBA;pwd=SQL;dbf=NLSCons.db" -ar OldLogs
>
> Which according to the help should upgrade my db from ver 8 to 9 and allow
> replication to continue.
>
> My first problem is the dbunload utility will gpf at the end of the reload
> for one of the dbs. The two other dbs complete the process with no gpf.
I
> have checked the validity of the dbs before the conversion and after and
all
> dbs are fine.
>
> Problem #2. During the dbunload process with the -ar switch the log file
is
> renamed to name.olg and moved to the OldLogs dir. The db will start fine
> but when I run dbremote is indicates it can't find the offset in the log
> file.
>
> What am I doing wrong or what is the correct procedure to upgrade a db
that
> is involved in replication?
>
> TIA
>
>