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.

dbvalid question?

5 posts in QAnywhere Last posting was on 2006-02-24 13:02:23.0Z
Altair Posted on 2006-02-22 12:32:42.0Z
From: Altair <altair@pagalba.com>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: dbvalid question?
Content-Type: text/plain; charset=ISO-8859-13; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: vpn-uk-035.sybase.com
Message-ID: <43fc4a96@forums-2-dub>
X-Original-Trace: 22 Feb 2006 03:27:18 -0800, vpn-uk-035.sybase.com
Lines: 7
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Feb 2006 03:27:21 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Feb 2006 04:32:42 -0800
X-Trace: forums-1-dub 1140611562 10.22.108.75 (22 Feb 2006 04:32:42 -0800)
X-Original-Trace: 22 Feb 2006 04:32:42 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:175
Article PK: 10458

Hello,

I have question about dbvalid utility. Does it do any modifications to
db file or just detects a problem? If problem is detected, is it
corecting these?

Thank you.


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-02-22 14:24:57.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: dbvalid question?
References: <43fc4a96@forums-2-dub>
In-Reply-To: <43fc4a96@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-13; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <43fc7439$1@forums-1-dub>
Date: 22 Feb 2006 06:24:57 -0800
X-Trace: forums-1-dub 1140618297 10.25.98.170 (22 Feb 2006 06:24:57 -0800)
X-Original-Trace: 22 Feb 2006 06:24:57 -0800, keating-dm20.sybase.com
Lines: 30
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:176
Article PK: 18769

DBVALID will impact the transaction log status, i.e., current offset
information, so you should ensure that it is run only against readonly
or copies of backups you may need for a recovery.

DBValid only checks the health of known conditions. It does not fix or
correct them. If a validation shows an error, you should go to you
recovery plan and restore from backup.
--

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 Case Express to report bugs http://case-express.sybase.com

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


Altair Posted on 2006-02-22 15:57:20.0Z
From: Altair <altair@pagalba.com>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: dbvalid question?
References: <43fc4a96@forums-2-dub> <43fc7439$1@forums-1-dub>
In-Reply-To: <43fc7439$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-13; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: adsl-81-7-90-117.takas.lt
Message-ID: <43fc7a8b$1@forums-2-dub>
X-Original-Trace: 22 Feb 2006 06:51:55 -0800, adsl-81-7-90-117.takas.lt
Lines: 14
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Feb 2006 06:51:56 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Feb 2006 07:57:20 -0800
X-Trace: forums-1-dub 1140623840 10.22.108.75 (22 Feb 2006 07:57:20 -0800)
X-Original-Trace: 22 Feb 2006 07:57:20 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:177
Article PK: 10457


Chris Keating(iAnywhere Solutions) wrote:
> DBVALID will impact the transaction log status, i.e., current offset
> information, so you should ensure that it is run only against readonly
> or copies of backups you may need for a recovery.
>
> DBValid only checks the health of known conditions. It does not fix or
> correct them. If a validation shows an error, you should go to you
> recovery plan and restore from backup.

According manual it should be run _before_ backup. But according this
explanation, it is not?
When it is better to run it in practice?

Thank you.


Stephen Rice Posted on 2006-02-22 19:58:18.0Z
From: Stephen Rice <srice_nospam@ianywhere.com>
Reply-To: srice_nospam@ianywhere.com
Organization: iAnywhere
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: dbvalid question?
References: <43fc4a96@forums-2-dub> <43fc7439$1@forums-1-dub> <43fc7a8b$1@forums-2-dub>
In-Reply-To: <43fc7a8b$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-13; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: srice-xp2.sybase.com
X-Original-NNTP-Posting-Host: srice-xp2.sybase.com
Message-ID: <43fcc25a@forums-1-dub>
Date: 22 Feb 2006 11:58:18 -0800
X-Trace: forums-1-dub 1140638298 10.25.98.210 (22 Feb 2006 11:58:18 -0800)
X-Original-Trace: 22 Feb 2006 11:58:18 -0800, srice-xp2.sybase.com
Lines: 36
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:178
Article PK: 10459


Altair wrote:
> Chris Keating(iAnywhere Solutions) wrote:
>
>> DBVALID will impact the transaction log status, i.e., current offset
>> information, so you should ensure that it is run only against readonly
>> or copies of backups you may need for a recovery.
>>
>> DBValid only checks the health of known conditions. It does not fix or
>> correct them. If a validation shows an error, you should go to you
>> recovery plan and restore from backup.
>
>
> According manual it should be run _before_ backup. But according this
> explanation, it is not?
> When it is better to run it in practice?
>
> Thank you.

--
A better way to think of it is that dbvalid should be run before you
consider a backup "good".

dbvalid should only be run against a database that has no other
connections. If you can ensure users are disconnected for the period it
takes to validate and backup then running dbvalid followed by dbbackup
works fine. If you can't have the downtime, then doing a backup and
validating a copy of the backup is your next approach.



/steve

Stephen Rice
Technical Services Manager
iAnywhere (a Sybase Company)
email: srice@ianywhere.com


Altair Posted on 2006-02-24 13:02:23.0Z
From: Altair <altair@pagalba.com>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: dbvalid question?
References: <43fc4a96@forums-2-dub> <43fc7439$1@forums-1-dub> <43fc7a8b$1@forums-2-dub> <43fcc25a@forums-1-dub>
In-Reply-To: <43fcc25a@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-13; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vpn-uk-025.sybase.com
X-Original-NNTP-Posting-Host: vpn-uk-025.sybase.com
Message-ID: <43ff03df$1@forums-1-dub>
Date: 24 Feb 2006 05:02:23 -0800
X-Trace: forums-1-dub 1140786143 158.76.101.25 (24 Feb 2006 05:02:23 -0800)
X-Original-Trace: 24 Feb 2006 05:02:23 -0800, vpn-uk-025.sybase.com
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:179
Article PK: 10463

Thank you Steve,
your answer is _very_ helpful! It cleares the situation very much.