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.

Dump and re-load into larger devices

6 posts in Windows NT Last posting was on 2000-05-22 04:34:25.0Z
Sybase Posted on 2000-05-20 13:57:27.0Z
From: "Sybase" <pschuman.NOSPAM@interserv.com>
Subject: Dump and re-load into larger devices
Date: Sat, 20 May 2000 08:57:27 -0500
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <KqPxcRmw$GA.261@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207-229-173-35.d.enteract.com 207.229.173.35
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2143
Article PK: 1089575

Is there any problem in dumping a database that initially lives in multiple
physical devices,
and then re-load it back into a single larger device ?

ie - dat file = 50 + 50 meg
log file = 20 + 20 meg

Dump -
then reload it into another database defined as:
dat file = 100 meg
log file = 40 meg

Phil -


David Owen Posted on 2000-05-20 15:40:41.0Z
Sender: dowen@kashka.midsomer.org
Subject: Re: Dump and re-load into larger devices
References: <KqPxcRmw$GA.261@forums.sybase.com>
From: David Owen <dowen@midsomer.org>
Organization: Midsomer Consultants Inc.
Date: 20 May 2000 09:40:41 -0600
Message-ID: <m2ya556xhi.fsf@kashka.midsomer.org>
Lines: 42
User-Agent: Gnus/5.0802 (Gnus v5.8.2) Emacs/20.5
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: h29-5d-f4-26324826.cg.shawcable.net 24.70.23.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2142
Article PK: 1089576

Phil> Is there any problem in dumping a database that initially lives
Phil> in multiple physical devices, and then re-load it back into a
Phil> single larger device ?

Phil> ie - dat file = 50 + 50 meg log file = 20 + 20 meg

Phil> Dump - then reload it into another database defined as: dat file
Phil> = 100 meg log file = 40 meg


Provided that the order of the devices is conserved, this is fine. So,

50D
50D
20L
20L

can be mapped to

100D
40L

but

50D
20L
50D
20L

can NOT. If you try to map this second scheme to 100D 40L the load process
will simply map your devices back to the 50D 20L 50D 20L scheme and you
will suddenly have both data and log on the same devices and be in a bit of
a mess.

dowen



--
David Owen Midsomer Consultants Inc. dowen@midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ


Phil Schuman Posted on 2000-05-20 20:04:42.0Z
From: "Phil Schuman" <pschuman.NOSPAM@interserv.com>
References: <KqPxcRmw$GA.261@forums.sybase.com> <m2ya556xhi.fsf@kashka.midsomer.org>
Subject: Re: Dump and re-load into larger devices
Date: Sat, 20 May 2000 15:04:42 -0500
Lines: 56
Organization: Abacus Group
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <suUzqepw$GA.304@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207-229-173-43.d.enteract.com 207.229.173.43
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2141
Article PK: 1089572

hi - tnx for the reply -
Since I've not jumped into the Sybase deep end, my knowledge here is at the
tiptoe level-
Where are these maps and order maintained, and how can I see them ?

Say I have a database that has been extended, say 50+50 = 100
and I have a problem with it, and need to restore,
what do I do ?
First of all - is there anyway to tell the sizes and mapping
from the dump (or the master table) - assuming the real user disk is
trashed -
which brings up the point of where to put the master vs user data bases
anyway, back to the restore question -
create two 50's or create a single 100 meg device/file ?

I guess I was looking at this a "defrag" kind of restore

Phil -

David Owen <dowen@midsomer.org> wrote in message
news:m2ya556xhi.fsf@kashka.midsomer.org...
> Provided that the order of the devices is conserved, this is fine. So,
>
> 50D
> 50D
> 20L
> 20L
>
> can be mapped to
>
> 100D
> 40L
>
> but
>
> 50D
> 20L
> 50D
> 20L
>
> can NOT. If you try to map this second scheme to 100D 40L the load
process
> will simply map your devices back to the 50D 20L 50D 20L scheme and you
> will suddenly have both data and log on the same devices and be in a bit
of
> a mess.
>
> dowen
>
>
>
> --
> David Owen Midsomer Consultants Inc. dowen@midsomer.org
> Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ


David Owen Posted on 2000-05-21 14:46:47.0Z
Sender: dowen@kashka.midsomer.org
Subject: Re: Dump and re-load into larger devices
References: <KqPxcRmw$GA.261@forums.sybase.com> <m2ya556xhi.fsf@kashka.midsomer.org> <suUzqepw$GA.304@forums.sybase.com>
From: David Owen <dowen@midsomer.org>
Organization: Midsomer Consultants Inc.
Date: 21 May 2000 08:46:47 -0600
Message-ID: <m2snvc2c6g.fsf@kashka.midsomer.org>
Lines: 45
User-Agent: Gnus/5.0802 (Gnus v5.8.2) Emacs/20.5
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: h29-5d-f4-26324826.cg.shawcable.net 24.70.23.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2139
Article PK: 1089573

>>>>> "Phil" == Phil Schuman <pschuman.NOSPAM@interserv.com> writes:

Phil> hi - tnx for the reply - Since I've not jumped into the Sybase
Phil> deep end, my knowledge here is at the tiptoe level- Where are
Phil> these maps and order maintained, and how can I see them ?

A mixture of sysdevices, sysdatabases ans sysusages. Have a look at the
stored proecs sp_helpdevice & sp_helpdb

You can do this by going to the sysbsystemprocs database (use
sybsystemprocs) and issuing

sp_helptext sp_helpdevice
go

etc

These will give you some idea of how the tables are fitted together. Do
you have a copy of the system tables diagram? It is very useful.


Phil> Say I have a database that has been extended, say 50+50 = 100 and
Phil> I have a problem with it, and need to restore, what do I do ?
Phil> First of all - is there anyway to tell the sizes and mapping from
Phil> the dump (or the master table) - assuming the real user disk is
Phil> trashed - which brings up the point of where to put the master vs
Phil> user data bases anyway, back to the restore question - create two
Phil> 50's or create a single 100 meg device/file ?

I do not know if it is possible to derive this from the dump itself (you
might want to look into the "listonly" option of load database, it might
tell you). Mostly, in my experience, it is simply a question of keeping
the information in some sort of log. In most environments, since databases
only ever grow, it is usually a safe bet that last year's dump will load
into this year's database, since the relevant parts of the structure will
be the same.

dowen




--
David Owen Midsomer Consultants Inc. dowen@midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ


Phil Schuman Posted on 2000-05-21 15:06:35.0Z
From: "Phil Schuman" <pschuman.NOSPAM@interserv.com>
References: <KqPxcRmw$GA.261@forums.sybase.com> <m2ya556xhi.fsf@kashka.midsomer.org> <suUzqepw$GA.304@forums.sybase.com> <m2snvc2c6g.fsf@kashka.midsomer.org>
Subject: Re: Dump and re-load into larger devices
Date: Sun, 21 May 2000 10:06:35 -0500
Lines: 12
Organization: Abacus Group
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <fCijvczw$GA.304@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207-229-173-14.d.enteract.com 207.229.173.14
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2138
Article PK: 1089569


David Owen <dowen@midsomer.org> wrote in message
news:m2snvc2c6g.fsf@kashka.midsomer.org...
> These will give you some idea of how the tables are fitted together. Do
> you have a copy of the system tables diagram? It is very useful.

no - where can I get some help in this area ?

Phil-


David Owen Posted on 2000-05-22 04:34:25.0Z
Sender: dowen@kashka.midsomer.org
Subject: Re: Dump and re-load into larger devices
References: <KqPxcRmw$GA.261@forums.sybase.com> <m2ya556xhi.fsf@kashka.midsomer.org> <suUzqepw$GA.304@forums.sybase.com> <m2snvc2c6g.fsf@kashka.midsomer.org> <fCijvczw$GA.304@forums.sybase.com>
From: David Owen <dowen@midsomer.org>
Organization: Midsomer Consultants Inc.
Date: 21 May 2000 22:34:25 -0600
Message-ID: <m2k8gn2ofi.fsf@kashka.midsomer.org>
Lines: 17
User-Agent: Gnus/5.0802 (Gnus v5.8.2) Emacs/20.5
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: h29-5d-f4-26324826.cg.shawcable.net 24.70.23.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2137
Article PK: 1089570

>>>>> "Phil" == Phil Schuman <pschuman.NOSPAM@interserv.com> writes:

Phil> David Owen <dowen@midsomer.org> wrote in message

Phil> news:m2snvc2c6g.fsf@kashka.midsomer.org...
>> These will give you some idea of how the tables are fitted together.
>> Do you have a copy of the system tables diagram? It is very useful.

Phil> no - where can I get some help in this area ?

You can order it from Sybase (part no 70204-01-1150-01 it says on my
copy). I do not think that they charge a whole deal for it. Sadly it is
for 11.5 only. I do not believe that there is an 11.9 version. I do not
know if there is a version for 12. Hope so.

--
David Owen Midsomer Consultants Inc. dowen@midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ