How to change ASE page size from 2k to 8k

evor...@yahoo.ca

unread,

Jan 29, 2009, 4:21:27 PM1/29/09

to

Hello

Can someone please tell me if is possible to change sybase default
page size from 2k to 8k, I already tried to create a new ASE with the
8K and use dump / load but fails due to source coming from a 2k page
size, I would like to avoid using bcp in / out

ASE 15.0.2 on solaris 10

Thank you
Maria

mnajs

unread,

Jan 30, 2009, 6:26:54 AM1/30/09

to

evor...@yahoo.ca pisze:

Hi.
Try to use 'sybmigrate'. More info.:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.utility/html/utility/utility123.htm

Regards,

--
Marcin Najs

evor...@yahoo.ca

unread,

Jan 30, 2009, 4:07:19 PM1/30/09

to

On Jan 30, 6:26 am, mnajs <marc...@uhc.com.pl> wrote:
> evora...@yahoo.ca pisze:

>
> > Hello
>
> > Can someone please tell me if is possible to change sybase default
> > page size from 2k to 8k, I already tried to create a new ASE with the
> > 8K and use dump / load but fails due to source coming from a 2k page
> > size, I would like to avoid using bcp in / out
>
> > ASE 15.0.2 on solaris 10
>
> > Thank you
> > Maria
>
> Hi.

> Try to use 'sybmigrate'. More info.:http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.as...
>
> Regards,
>
> --
> Marcin Najs

Unfortenately the tool gives all kinds or errors out when i invoke
it

2009/01/30 15:55:11.516|TASK (5:3)|ERROR|Error during data migration
of 'test_table.dbo.test_table'.
2009/01/30 15:55:11.517|TASK (5:3)|ERROR|Msg 11216, Level 16, State
13
Server UAT_DS, Line 1, Status 0, TranState 0
Internal Ct-Lib/Cs-Lib error 16973838: 'blk_init(): blk layer: CT
library error: Failed when CT_Lib routine ct_results() called.'.
Msg 4847, Level 16, State 1
Server mtrs$1, Line 1, Status 0, TranState 0
BCP insert operation is disabled when data size is changing between
client and server character sets. Please use BCP's -Y option to invoke
client-side
conversion.
Command has been aborted.

mnajs

unread,

Feb 2, 2009, 4:32:26 AM2/2/09

to

evor...@yahoo.ca pisze:

> 2009/01/30 15:55:11.516|TASK (5:3)|ERROR|Error during data migration
> of 'test_table.dbo.test_table'.
> 2009/01/30 15:55:11.517|TASK (5:3)|ERROR|Msg 11216, Level 16, State
> 13
> Server UAT_DS, Line 1, Status 0, TranState 0
> Internal Ct-Lib/Cs-Lib error 16973838: 'blk_init(): blk layer: CT
> library error: Failed when CT_Lib routine ct_results() called.'.
> Msg 4847, Level 16, State 1
> Server mtrs$1, Line 1, Status 0, TranState 0
> BCP insert operation is disabled when data size is changing between
> client and server character sets. Please use BCP's -Y option to invoke
> client-side
> conversion.
> Command has been aborted.

Did you read pre-migration considerations from manual? i.e.:
1. language/sort order configuration on source/target server
2. "To enable conversion of character sets that do not have an internal
Adaptive Server conversion routine, configure the target Adaptive Server
with enable unicode conversions set to 1." (maybe this parameter fits to
your case)
3. I would install newest patches (ESD #6) for both ASE instances before
migration
...

I'm not an expert but I don't know how your ASE servers are configured...

Regards,

--
Marcin Najs

michael...@gmail.com

unread,

Feb 2, 2009, 7:24:08 AM2/2/09

to

Use -Y, or -Jiso1, or change your LC_LANG and/or LC_ALL env. variable
so that you aren't in a UTF8 environement (note - if you're running
linux then there is a good chance that you have a UTF8 environment by
default, even if you don't need it for your language).

Michael