Problem with loading a .dump file

[Green Dolphin]

Hi all,

I am having some trouble with loading a .dump file on ASE 12.5
Got the following error message, couldn't anyone please help?

Thanks a lot.

Backup Server session id is: 5. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume
change request from the Backup Server.
Backup Server: 4.177.2.1: The database page size of 8192 bytes
obtained from ASE is different from the database page size of 2048
bytes read from the dump header. The LOAD session must exit.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP
or LOAD session must exit.
Backup Server: 6.32.2.3: /tmp/sytsdb.dump: volume not valid or not
requested (server:, session id:5.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP
or LOAD session must exit.
Msg 8009, Level 16, State 1:
Server 'se3pc09', Line 1:
Error encountered by Backup Server. Please refer to Backup Server
messages for details.

Thanks,

[Marc M]

ss...@hutchcity.com (Green Dolphin) wrote in message news:<f3d582aa.0401...@posting.google.com>...

> Hi all,
>
> I am having some trouble with loading a .dump file on ASE 12.5
> Got the following error message, couldn't anyone please help?
>
> Thanks a lot.
>
> Backup Server session id is: 5. Use this value when executing the
> 'sp_volchanged' system stored procedure after fulfilling any volume
> change request from the Backup Server.
> Backup Server: 4.177.2.1: The database page size of 8192 bytes
> obtained from ASE is different from the database page size of 2048
> bytes read from the dump header. The LOAD session must exit.

<Snip>

Unfortunately you cannot load a dump of a DB with a different logical
page size. Create a new ASE server with a logical page size of 2K and
then load the dump. Then use BCP to copy the data table by table to
your target DB if you really want an 8K server. Alternately, there is
a migration tool (I haven't tried it) as per the Sybase Knowledge Base
article below. The KB at sybase.com is an excellent resource BTW if
you haven't checked it out yet.

Problem Description:
Can you load a 2K dump onto a 4K page server?
Key Words: ASE dump database load database

Tip or Workaround:
Beginning with ASE 12.5.0.1 IR, Sybase has a migration utility to
migrate a database from a server of one page size to a server of a
different page size.

Case Id: 10819329

Resolution:
You cannot dump and load from a database of one page size to another
page size - in this example from 2K to 4K. Use BCP or the 12.5.0.1 IR
migration utility.
Resolutions: utilities

Other Sources Related to Issue(Type - Location):

Manual - Migration Utility Guide included with 12.5.0.1 IR.
(../Server/docs/sybmigrate/MT-quickstart.txt)