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.

problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4

9 posts in Backup and Recovery Last posting was on 2009-10-21 13:21:57.0Z
Sergio Posted on 2009-10-16 15:44:36.0Z
Sender: 2b82.4ad892d3.1804289383@sybase.com
From: Sergio
Newsgroups: sybase.public.ase.backup+recovery
Subject: problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ad894e4.2bdc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Oct 2009 08:44:36 -0700
X-Trace: forums-1-dub 1255707876 10.22.241.41 (16 Oct 2009 08:44:36 -0700)
X-Original-Trace: 16 Oct 2009 08:44:36 -0700, 10.22.241.41
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4048
Article PK: 48135

Hi,

I'm facing problems when I'm trying load a dump executed on
ASE 12.5.0.3.

One example is: I created my database exactly like on the
version 12.5.0.3 on 12.5.4 (with separeted devices for data
and log). But after the load, my device used for data was
changed for both data and log.

The platform of the ASE 12.5.0.3 is Solaris 8 and for 12.5.4
is Intel Solaris. I confirmed that this is supported.

So did you any idea about this problem?

Thanks in advance,

Sergio


"Mark A. Parsons" <iron_horse Posted on 2009-10-16 17:07:32.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4
References: <4ad894e4.2bdc.1681692777@sybase.com>
In-Reply-To: <4ad894e4.2bdc.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091014-0, 10/14/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ad8a854$1@forums-1-dub>
Date: 16 Oct 2009 10:07:32 -0700
X-Trace: forums-1-dub 1255712852 10.22.241.152 (16 Oct 2009 10:07:32 -0700)
X-Original-Trace: 16 Oct 2009 10:07:32 -0700, vip152.sybase.com
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4049
Article PK: 48136

You haven't provided enough details ...

My guess is that either a) your 'create/alter database' commands were not quite correct or b) there is some
fragmentation of devices in the 12.5.4 dataserver which is leading to more, but smaller, fragments in use by your new
database.

I'd suggest you post the results from running the following query in *both* dataservers:

=========================

-- replace <dbname> with the name of your database

select *
from master..sysusages
where dbname = '<dbname>'
order by lstart
go
=========================

Sergio wrote:
> Hi,
>
> I'm facing problems when I'm trying load a dump executed on
> ASE 12.5.0.3.
>
> One example is: I created my database exactly like on the
> version 12.5.0.3 on 12.5.4 (with separeted devices for data
> and log). But after the load, my device used for data was
> changed for both data and log.
>
> The platform of the ASE 12.5.0.3 is Solaris 8 and for 12.5.4
> is Intel Solaris. I confirmed that this is supported.
>
> So did you any idea about this problem?
>
> Thanks in advance,
>
> Sergio


"Mark A. Parsons" <iron_horse Posted on 2009-10-16 17:08:08.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4
References: <4ad894e4.2bdc.1681692777@sybase.com> <4ad8a854$1@forums-1-dub>
In-Reply-To: <4ad8a854$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091014-0, 10/14/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ad8a878$1@forums-1-dub>
Date: 16 Oct 2009 10:08:08 -0700
X-Trace: forums-1-dub 1255712888 10.22.241.152 (16 Oct 2009 10:08:08 -0700)
X-Original-Trace: 16 Oct 2009 10:08:08 -0700, vip152.sybase.com
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4050
Article PK: 48137

Go ahead and also post the 'create/alter database' commands you used to create your new 12.5.4 database.

Mark A. Parsons wrote:
> You haven't provided enough details ...
>
> My guess is that either a) your 'create/alter database' commands were
> not quite correct or b) there is some fragmentation of devices in the
> 12.5.4 dataserver which is leading to more, but smaller, fragments in
> use by your new database.
>
> I'd suggest you post the results from running the following query in
> *both* dataservers:
>
> =========================
>
> -- replace <dbname> with the name of your database
>
> select *
> from master..sysusages
> where dbname = '<dbname>'
> order by lstart
> go
> =========================
>
>
>
> Sergio wrote:
>> Hi,
>>
>> I'm facing problems when I'm trying load a dump executed on
>> ASE 12.5.0.3.
>>
>> One example is: I created my database exactly like on the
>> version 12.5.0.3 on 12.5.4 (with separeted devices for data
>> and log). But after the load, my device used for data was
>> changed for both data and log.
>>
>> The platform of the ASE 12.5.0.3 is Solaris 8 and for 12.5.4
>> is Intel Solaris. I confirmed that this is supported.
>>
>> So did you any idea about this problem?
>>
>> Thanks in advance,
>>
>> Sergio


Sergio Posted on 2009-10-16 17:58:47.0Z
Sender: 2f84.4ad8ae33.1804289383@sybase.com
From: Sergio
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ad8b457.3050.1681692777@sybase.com>
References: <4ad8a878$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Oct 2009 10:58:47 -0700
X-Trace: forums-1-dub 1255715927 10.22.241.41 (16 Oct 2009 10:58:47 -0700)
X-Original-Trace: 16 Oct 2009 10:58:47 -0700, 10.22.241.41
Lines: 61
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4051
Article PK: 48138

Hi Mark,

I created the db where I loaded the data just with create
database with one device for data and another with log. The
size was a litle big that the db of the dump.

This is all info that I'm adding.

Best Regards,

Sergio

> Go ahead and also post the 'create/alter database'
> commands you used to create your new 12.5.4 database.
>
> Mark A. Parsons wrote:
> > You haven't provided enough details ...
> >
> > My guess is that either a) your 'create/alter database'
> > commands were not quite correct or b) there is some
> > fragmentation of devices in the 12.5.4 dataserver which
> > is leading to more, but smaller, fragments in use by
> > your new database.
> > I'd suggest you post the results from running the
> > following query in *both* dataservers:
> >
> > =========================
> >
> > -- replace <dbname> with the name of your database
> >
> > select *
> > from master..sysusages
> > where dbname = '<dbname>'
> > order by lstart
> > go
> > =========================
> >
> >
> >
> > Sergio wrote:
> >> Hi,
> >>
> >> I'm facing problems when I'm trying load a dump
> executed on >> ASE 12.5.0.3.
> >>
> >> One example is: I created my database exactly like on
> the >> version 12.5.0.3 on 12.5.4 (with separeted devices
> for data >> and log). But after the load, my device used
> for data was >> changed for both data and log.
> >>
> >> The platform of the ASE 12.5.0.3 is Solaris 8 and for
> 12.5.4 >> is Intel Solaris. I confirmed that this is
> supported. >>
> >> So did you any idea about this problem?
> >>
> >> Thanks in advance,
> >>
> >> Sergio


"Mark A. Parsons" <iron_horse Posted on 2009-10-16 21:00:20.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4
References: <4ad8a878$1@forums-1-dub> <4ad8b457.3050.1681692777@sybase.com>
In-Reply-To: <4ad8b457.3050.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091014-0, 10/14/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ad8dee4$1@forums-1-dub>
Date: 16 Oct 2009 14:00:20 -0700
X-Trace: forums-1-dub 1255726820 10.22.241.152 (16 Oct 2009 14:00:20 -0700)
X-Original-Trace: 16 Oct 2009 14:00:20 -0700, vip152.sybase.com
Lines: 68
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4052
Article PK: 48141

You haven't provided any information that we can use to help you.

If you don't want to provide any additional info (eg, the queries I asked you to run), no problem ...

This is all the suggestions I'm adding.

Sergio wrote:
> Hi Mark,
>
> I created the db where I loaded the data just with create
> database with one device for data and another with log. The
> size was a litle big that the db of the dump.
>
> This is all info that I'm adding.
>
> Best Regards,
>
> Sergio
>
>
>
>
>> Go ahead and also post the 'create/alter database'
>> commands you used to create your new 12.5.4 database.
>>
>> Mark A. Parsons wrote:
>>> You haven't provided enough details ...
>>>
>>> My guess is that either a) your 'create/alter database'
>>> commands were not quite correct or b) there is some
>>> fragmentation of devices in the 12.5.4 dataserver which
>>> is leading to more, but smaller, fragments in use by
>>> your new database.
>>> I'd suggest you post the results from running the
>>> following query in *both* dataservers:
>>>
>>> =========================
>>>
>>> -- replace <dbname> with the name of your database
>>>
>>> select *
>>> from master..sysusages
>>> where dbname = '<dbname>'
>>> order by lstart
>>> go
>>> =========================
>>>
>>>
>>>
>>> Sergio wrote:
>>>> Hi,
>>>>
>>>> I'm facing problems when I'm trying load a dump
>> executed on >> ASE 12.5.0.3.
>>>> One example is: I created my database exactly like on
>> the >> version 12.5.0.3 on 12.5.4 (with separeted devices
>> for data >> and log). But after the load, my device used
>> for data was >> changed for both data and log.
>>>> The platform of the ASE 12.5.0.3 is Solaris 8 and for
>> 12.5.4 >> is Intel Solaris. I confirmed that this is
>> supported. >>
>>>> So did you any idea about this problem?
>>>>
>>>> Thanks in advance,
>>>>
>>>> Sergio


"Mark A. Parsons" <iron_horse Posted on 2009-10-19 16:57:45.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4
References: <4ad8dee4$1@forums-1-dub> <4adc9501.542.1681692777@sybase.com>
In-Reply-To: <4adc9501.542.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091014-0, 10/14/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4adc9a89$1@forums-1-dub>
Date: 19 Oct 2009 09:57:45 -0700
X-Trace: forums-1-dub 1255971465 10.22.241.152 (19 Oct 2009 09:57:45 -0700)
X-Original-Trace: 19 Oct 2009 09:57:45 -0700, vip152.sybase.com
Lines: 24
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4054
Article PK: 48142

Sergio wrote:
... snip ...

> If you need more info, please, let me know.

Go back and see what I requested in an earlier post:

... snip ...

>>>>> I'd suggest you post the results from running the
>>>>> following query in *both* dataservers:
>>>>>
>>>>> =========================
>>>>>
>>>>> -- replace <dbname> with the name of your database
>>>>>
>>>>> select *
>>>>> from master..sysusages
>>>>> where dbname = '<dbname>'
>>>>> order by lstart
>>>>> go
>>>>> =========================


Sherlock, Kevin [TeamSybase] Posted on 2009-10-19 17:58:54.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.backup+recovery
References: <4ad8dee4$1@forums-1-dub> <4adc9501.542.1681692777@sybase.com>
Subject: Re: problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4
Lines: 324
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4adca8de$1@forums-1-dub>
Date: 19 Oct 2009 10:58:54 -0700
X-Trace: forums-1-dub 1255975134 10.22.241.152 (19 Oct 2009 10:58:54 -0700)
X-Original-Trace: 19 Oct 2009 10:58:54 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4055
Article PK: 48144

You should post the output that Mark has asked for. He asks for it for a
very good reason.

In that version of ASE (12.5.0.3) the output of sp_help is ordered by device
name, and not the order in which the devices are allocated to the database.

Posting the output of Mark's queries (on your source and destination server)
will get you a resolution quicker than going in circles without them.

<Sergio> wrote in message news:4adc9501.542.1681692777@sybase.com...
> Hi Mark,
>
>
> As I explained I'm loading information that are comming from
> Sybase ASE version Adaptive Server Enterprise/12.5.0.3/EBF
> 11442 ESD#4/P/Sun_svr4/OS 5.8/rel12503/1939/64-bit/FBO/Sun
> Sep 21 05:21:37 2003
>
> I created the database with the create database command
> using two devices for data and log.
>
> After the load completion (and online command) I see on the
> sp_helpdb output that the log is mixed as you can see
> bellow.
>
> 1 - the sp_helpdb's output:
>
> 1>sp_helpdb gw_oracle
> 2>go
> name db_size owner dbid created status
>
> ---- ------- ----- ----------- ------- ------
>
> gw_oracle 4096.0 MB scbonfim 22 Oct 16, 2009 no options set
>
> device_fragments size usage created free kbytes
>
> ---------------- ---- ----- ------- -----------
>
> GWORA_DAT01 1024.0 MB data only Oct 16 2009 3:08PM 18816
>
> GWORA_DAT01 1024.0 MB log only Oct 16 2009 3:08PM not
> applicable
>
> GWORA_DAT01 512.0 MB data only Oct 16 2009 3:08PM 17044
>
> GWORA_LOG01 488.0 MB data only Oct 16 2009 3:08PM 494534
>
> GWORA_LOG01 1048.0 MB log only Oct 16 2009 3:08PM not
> applicable
>
>
> -
>
> log only free kbytes = 2113436
>
> 2 - the log's dump
>
> Oct 16 15:07:58 2009: Backup Server: 6.28.1.1: Dumpfile name
> '_oracle092890CB21' section number 1 mounted on disk file
> '/sybase125/gw_oracle.dmp'
> Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 52424 kilobytes LOADED.
> Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 86670 kilobytes LOADED.
> Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 138770 kilobytes LOADED.
> Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 173462 kilobytes LOADED.
> Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 225116 kilobytes LOADED.
> Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 259808 kilobytes LOADED.
> Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 294500 kilobytes LOADED.
> Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 346154 kilobytes LOADED.
> Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 380846 kilobytes LOADED.
> Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 432822 kilobytes LOADED.
> Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 467576 kilobytes LOADED.
> Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 519614 kilobytes LOADED.
> Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 554306 kilobytes LOADED.
> Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 588998 kilobytes LOADED.
> Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 640652 kilobytes LOADED.
> Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 675344 kilobytes LOADED.
> Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 726998 kilobytes LOADED.
> Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 761690 kilobytes LOADED.
> Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 813728 kilobytes LOADED.
> Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 848036 kilobytes LOADED.
> Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 882728 kilobytes LOADED.
> Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 935150 kilobytes LOADED.
> Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 969458 kilobytes LOADED.
> Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1021496 kilobytes LOADED.
> Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1056188 kilobytes LOADED.
> Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1090880 kilobytes LOADED.
> Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1142534 kilobytes LOADED.
> Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1177226 kilobytes LOADED.
> Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1228880 kilobytes LOADED.
> Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1263572 kilobytes LOADED.
> Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1315610 kilobytes LOADED.
> Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1349856 kilobytes LOADED.
> Oct 16 15:08:12 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1384610 kilobytes LOADED.
> Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1437032 kilobytes LOADED.
> Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1471278 kilobytes LOADED.
> Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1523378 kilobytes LOADED.
> Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1558070 kilobytes LOADED.
> Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1609724 kilobytes LOADED.
> Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1643264 kilobytes LOADED.
> Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1686854 kilobytes LOADED.
> Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1730060 kilobytes LOADED.
> Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1773266 kilobytes LOADED.
> Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1816344 kilobytes LOADED.
> Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1859550 kilobytes LOADED.
> Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1888482 kilobytes LOADED.
> Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1931688 kilobytes LOADED.
> Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 1981038 kilobytes LOADED.
> Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2023794 kilobytes LOADED.
> Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2066934 kilobytes LOADED.
> Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2108732 kilobytes LOADED.
> Oct 16 15:08:21 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2152256 kilobytes LOADED.
> Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2195842 kilobytes LOADED.
> Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2238982 kilobytes LOADED.
> Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2282122 kilobytes LOADED.
> Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2321806 kilobytes LOADED.
> Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2354194 kilobytes LOADED.
> Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2392470 kilobytes LOADED.
> Oct 16 15:08:25 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2435610 kilobytes LOADED.
> Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2478750 kilobytes LOADED.
> Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2521890 kilobytes LOADED.
> Oct 16 15:08:27 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2564968 kilobytes LOADED.
> Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2608492 kilobytes LOADED.
> Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2652078 kilobytes LOADED.
> Oct 16 15:08:29 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2695218 kilobytes LOADED.
> Oct 16 15:08:30 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2738358 kilobytes LOADED.
> Oct 16 15:08:31 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2781498 kilobytes LOADED.
> Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2824576 kilobytes LOADED.
> Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2868100 kilobytes LOADED.
> Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2911686 kilobytes LOADED.
> Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2954826 kilobytes LOADED.
> Oct 16 15:08:34 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 2997966 kilobytes LOADED.
> Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3041106 kilobytes LOADED.
> Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3062676 kilobytes LOADED.
> Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3105688 kilobytes LOADED.
> Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3147102 kilobytes LOADED.
> Oct 16 15:08:37 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3194468 kilobytes LOADED.
> Oct 16 15:08:38 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3235944 kilobytes LOADED.
> Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3279084 kilobytes LOADED.
> Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3322224 kilobytes LOADED.
> Oct 16 15:08:40 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3365302 kilobytes LOADED.
> Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3408826 kilobytes LOADED.
> Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3452412 kilobytes LOADED.
> Oct 16 15:08:42 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3491266 kilobytes LOADED.
> Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3526020 kilobytes LOADED.
> Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
> gw_oracle: 3531150 kilobytes LOADED.
> Oct 16 15:08:43 2009: Backup Server: 3.42.1.1: LOAD is
> complete (database gw_oracle).
>
> 3 - the full Sybase ASE version:
>
> Adaptive Server Enterprise/12.5.4/EBF 13395/P/Solaris
> AMD64/OS 5.10/ase1254/2006/64-bit/OPT/Sat May 20 00:11:23
> 2006
>
>
> If you need more info, please, let me know.
>
> Thanks again,
>
>
> Sergio
>
>
>
>
>
>> You haven't provided any information that we can use to
>> help you.
>>
>> If you don't want to provide any additional info (eg, the
>> queries I asked you to run), no problem ...
>>
>> This is all the suggestions I'm adding.
>>
>>
>>
>> Sergio wrote:
>> > Hi Mark,
>> >
>> > I created the db where I loaded the data just with
>> > create database with one device for data and another
>> > with log. The size was a litle big that the db of the
>> > dump.
>> > This is all info that I'm adding.
>> >
>> > Best Regards,
>> >
>> > Sergio
>> >
>> >
>> >
>> >
>> >> Go ahead and also post the 'create/alter database'
>> >> commands you used to create your new 12.5.4 database.
>> >>
>> >> Mark A. Parsons wrote:
>> >>> You haven't provided enough details ...
>> >>>
>> >>> My guess is that either a) your 'create/alter
>> database' >>> commands were not quite correct or b) there
>> is some >>> fragmentation of devices in the 12.5.4
>> dataserver which >>> is leading to more, but smaller,
>> fragments in use by >>> your new database.
>> >>> I'd suggest you post the results from running the
>> >>> following query in *both* dataservers:
>> >>>
>> >>> =========================
>> >>>
>> >>> -- replace <dbname> with the name of your database
>> >>>
>> >>> select *
>> >>> from master..sysusages
>> >>> where dbname = '<dbname>'
>> >>> order by lstart
>> >>> go
>> >>> =========================
>> >>>
>> >>>
>> >>>
>> >>> Sergio wrote:
>> >>>> Hi,
>> >>>>
>> >>>> I'm facing problems when I'm trying load a dump
>> >> executed on >> ASE 12.5.0.3.
>> >>>> One example is: I created my database exactly like on
>> >> the >> version 12.5.0.3 on 12.5.4 (with separeted
>> devices >> for data >> and log). But after the load, my
>> device used >> for data was >> changed for both data and
>> log. >>>> The platform of the ASE 12.5.0.3 is Solaris 8
>> and for >> 12.5.4 >> is Intel Solaris. I confirmed that
>> this is >> supported. >>
>> >>>> So did you any idea about this problem?
>> >>>>
>> >>>> Thanks in advance,
>> >>>>
>> >>>> Sergio


Sergio Posted on 2009-10-21 13:21:57.0Z
Sender: 976.4adf09d4.1804289383@sybase.com
From: Sergio
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: problem with dump on Sybase ASE 12.5.0.3 and load on ASE 12.5.4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4adf0af5.9ab.1681692777@sybase.com>
References: <4adca8de$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Oct 2009 06:21:57 -0700
X-Trace: forums-1-dub 1256131317 10.22.241.41 (21 Oct 2009 06:21:57 -0700)
X-Original-Trace: 21 Oct 2009 06:21:57 -0700, 10.22.241.41
Lines: 340
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4058
Article PK: 48146

Hi,

Thanks for your attencion on this case.

The resolution for this problem is create the database
exactly as the database where we make a dump.

This is all.

Best Regards,


Sergio

> You should post the output that Mark has asked for. He
> asks for it for a very good reason.
>
> In that version of ASE (12.5.0.3) the output of sp_help is
> ordered by device name, and not the order in which the
> devices are allocated to the database.
>
> Posting the output of Mark's queries (on your source and
> destination server) will get you a resolution quicker
> than going in circles without them.
>
> <Sergio> wrote in message
> > news:4adc9501.542.1681692777@sybase.com... Hi Mark,
> >
> >
> > As I explained I'm loading information that are comming
> > from Sybase ASE version Adaptive Server
> > Enterprise/12.5.0.3/EBF 11442 ESD#4/P/Sun_svr4/OS
> > 5.8/rel12503/1939/64-bit/FBO/Sun Sep 21 05:21:37 2003
> >
> > I created the database with the create database command
> > using two devices for data and log.
> >
> > After the load completion (and online command) I see on
> > the sp_helpdb output that the log is mixed as you can
> > see bellow.
> >
> > 1 - the sp_helpdb's output:
> >
> > 1>sp_helpdb gw_oracle
> > 2>go
> > name db_size owner dbid created status
> >
> > ---- ------- ----- ----------- ------- ------
> >
> > gw_oracle 4096.0 MB scbonfim 22 Oct 16, 2009 no options
> set >
> > device_fragments size usage created free kbytes
> >
> > ---------------- ---- ----- ------- -----------
> >
> > GWORA_DAT01 1024.0 MB data only Oct 16 2009 3:08PM 18816
> >
> > GWORA_DAT01 1024.0 MB log only Oct 16 2009 3:08PM not
> > applicable
> >
> > GWORA_DAT01 512.0 MB data only Oct 16 2009 3:08PM 17044
> >
> > GWORA_LOG01 488.0 MB data only Oct 16 2009 3:08PM 494534
> >
> > GWORA_LOG01 1048.0 MB log only Oct 16 2009 3:08PM not
> > applicable
> >
> >
> > -
> >
> > log only free kbytes = 2113436
> >
> > 2 - the log's dump
> >
> > Oct 16 15:07:58 2009: Backup Server: 6.28.1.1: Dumpfile
> > name '_oracle092890CB21' section number 1 mounted on
> > disk file '/sybase125/gw_oracle.dmp'
> > Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 52424 kilobytes LOADED.
> > Oct 16 15:07:58 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 86670 kilobytes LOADED.
> > Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 138770 kilobytes LOADED.
> > Oct 16 15:07:59 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 173462 kilobytes LOADED.
> > Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 225116 kilobytes LOADED.
> > Oct 16 15:08:00 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 259808 kilobytes LOADED.
> > Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 294500 kilobytes LOADED.
> > Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 346154 kilobytes LOADED.
> > Oct 16 15:08:01 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 380846 kilobytes LOADED.
> > Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 432822 kilobytes LOADED.
> > Oct 16 15:08:02 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 467576 kilobytes LOADED.
> > Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 519614 kilobytes LOADED.
> > Oct 16 15:08:03 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 554306 kilobytes LOADED.
> > Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 588998 kilobytes LOADED.
> > Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 640652 kilobytes LOADED.
> > Oct 16 15:08:04 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 675344 kilobytes LOADED.
> > Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 726998 kilobytes LOADED.
> > Oct 16 15:08:05 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 761690 kilobytes LOADED.
> > Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 813728 kilobytes LOADED.
> > Oct 16 15:08:06 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 848036 kilobytes LOADED.
> > Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 882728 kilobytes LOADED.
> > Oct 16 15:08:07 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 935150 kilobytes LOADED.
> > Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 969458 kilobytes LOADED.
> > Oct 16 15:08:08 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1021496 kilobytes LOADED.
> > Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1056188 kilobytes LOADED.
> > Oct 16 15:08:09 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1090880 kilobytes LOADED.
> > Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1142534 kilobytes LOADED.
> > Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1177226 kilobytes LOADED.
> > Oct 16 15:08:10 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1228880 kilobytes LOADED.
> > Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1263572 kilobytes LOADED.
> > Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1315610 kilobytes LOADED.
> > Oct 16 15:08:11 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1349856 kilobytes LOADED.
> > Oct 16 15:08:12 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1384610 kilobytes LOADED.
> > Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1437032 kilobytes LOADED.
> > Oct 16 15:08:13 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1471278 kilobytes LOADED.
> > Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1523378 kilobytes LOADED.
> > Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1558070 kilobytes LOADED.
> > Oct 16 15:08:14 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1609724 kilobytes LOADED.
> > Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1643264 kilobytes LOADED.
> > Oct 16 15:08:15 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1686854 kilobytes LOADED.
> > Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1730060 kilobytes LOADED.
> > Oct 16 15:08:16 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1773266 kilobytes LOADED.
> > Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1816344 kilobytes LOADED.
> > Oct 16 15:08:17 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1859550 kilobytes LOADED.
> > Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1888482 kilobytes LOADED.
> > Oct 16 15:08:18 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1931688 kilobytes LOADED.
> > Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 1981038 kilobytes LOADED.
> > Oct 16 15:08:19 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2023794 kilobytes LOADED.
> > Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2066934 kilobytes LOADED.
> > Oct 16 15:08:20 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2108732 kilobytes LOADED.
> > Oct 16 15:08:21 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2152256 kilobytes LOADED.
> > Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2195842 kilobytes LOADED.
> > Oct 16 15:08:22 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2238982 kilobytes LOADED.
> > Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2282122 kilobytes LOADED.
> > Oct 16 15:08:23 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2321806 kilobytes LOADED.
> > Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2354194 kilobytes LOADED.
> > Oct 16 15:08:24 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2392470 kilobytes LOADED.
> > Oct 16 15:08:25 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2435610 kilobytes LOADED.
> > Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2478750 kilobytes LOADED.
> > Oct 16 15:08:26 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2521890 kilobytes LOADED.
> > Oct 16 15:08:27 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2564968 kilobytes LOADED.
> > Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2608492 kilobytes LOADED.
> > Oct 16 15:08:28 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2652078 kilobytes LOADED.
> > Oct 16 15:08:29 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2695218 kilobytes LOADED.
> > Oct 16 15:08:30 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2738358 kilobytes LOADED.
> > Oct 16 15:08:31 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2781498 kilobytes LOADED.
> > Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2824576 kilobytes LOADED.
> > Oct 16 15:08:32 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2868100 kilobytes LOADED.
> > Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2911686 kilobytes LOADED.
> > Oct 16 15:08:33 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2954826 kilobytes LOADED.
> > Oct 16 15:08:34 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 2997966 kilobytes LOADED.
> > Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3041106 kilobytes LOADED.
> > Oct 16 15:08:35 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3062676 kilobytes LOADED.
> > Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3105688 kilobytes LOADED.
> > Oct 16 15:08:36 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3147102 kilobytes LOADED.
> > Oct 16 15:08:37 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3194468 kilobytes LOADED.
> > Oct 16 15:08:38 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3235944 kilobytes LOADED.
> > Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3279084 kilobytes LOADED.
> > Oct 16 15:08:39 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3322224 kilobytes LOADED.
> > Oct 16 15:08:40 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3365302 kilobytes LOADED.
> > Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3408826 kilobytes LOADED.
> > Oct 16 15:08:41 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3452412 kilobytes LOADED.
> > Oct 16 15:08:42 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3491266 kilobytes LOADED.
> > Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3526020 kilobytes LOADED.
> > Oct 16 15:08:43 2009: Backup Server: 4.58.1.1: Database
> > gw_oracle: 3531150 kilobytes LOADED.
> > Oct 16 15:08:43 2009: Backup Server: 3.42.1.1: LOAD is
> > complete (database gw_oracle).
> >
> > 3 - the full Sybase ASE version:
> >
> > Adaptive Server Enterprise/12.5.4/EBF 13395/P/Solaris
> > AMD64/OS 5.10/ase1254/2006/64-bit/OPT/Sat May 20
> > 00:11:23 2006
> >
> >
> > If you need more info, please, let me know.
> >
> > Thanks again,
> >
> >
> > Sergio
> >
> >
> >
> >
> >
> >> You haven't provided any information that we can use to
> >> help you.
> >>
> >> If you don't want to provide any additional info (eg,
> the >> queries I asked you to run), no problem ...
> >>
> >> This is all the suggestions I'm adding.
> >>
> >>
> >>
> >> Sergio wrote:
> >> > Hi Mark,
> >> >
> >> > I created the db where I loaded the data just with
> >> > create database with one device for data and another
> >> > with log. The size was a litle big that the db of the
> >> > dump.
> >> > This is all info that I'm adding.
> >> >
> >> > Best Regards,
> >> >
> >> > Sergio
> >> >
> >> >
> >> >
> >> >
> >> >> Go ahead and also post the 'create/alter database'
> >> >> commands you used to create your new 12.5.4
> database. >> >>
> >> >> Mark A. Parsons wrote:
> >> >>> You haven't provided enough details ...
> >> >>>
> >> >>> My guess is that either a) your 'create/alter
> >> database' >>> commands were not quite correct or b)
> there >> is some >>> fragmentation of devices in the
> 12.5.4 >> dataserver which >>> is leading to more, but
> smaller, >> fragments in use by >>> your new database.
> >> >>> I'd suggest you post the results from running the
> >> >>> following query in *both* dataservers:
> >> >>>
> >> >>> =========================
> >> >>>
> >> >>> -- replace <dbname> with the name of your database
> >> >>>
> >> >>> select *
> >> >>> from master..sysusages
> >> >>> where dbname = '<dbname>'
> >> >>> order by lstart
> >> >>> go
> >> >>> =========================
> >> >>>
> >> >>>
> >> >>>
> >> >>> Sergio wrote:
> >> >>>> Hi,
> >> >>>>
> >> >>>> I'm facing problems when I'm trying load a dump
> >> >> executed on >> ASE 12.5.0.3.
> >> >>>> One example is: I created my database exactly like
> on >> >> the >> version 12.5.0.3 on 12.5.4 (with separeted
> >> devices >> for data >> and log). But after the load, my
> >> device used >> for data was >> changed for both data
> and >> log. >>>> The platform of the ASE 12.5.0.3 is
> Solaris 8 >> and for >> 12.5.4 >> is Intel Solaris. I
> confirmed that >> this is >> supported. >>
> >> >>>> So did you any idea about this problem?
> >> >>>>
> >> >>>> Thanks in advance,
> >> >>>>
> >> >>>> Sergio
>
>