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

evoradba (AT) yahoo (DOT) ca pisze:
Hi.
Try to use 'sybmigrate'. More info.:
http://infocenter.sybase.com/help/in...utility123.htm


Regards,

--
Marcin Najs

On Jan 30, 6:26*am, mnajs <marc... (AT) uhc (DOT) com.pl> wrote:
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.

evoradba (AT) yahoo (DOT) ca pisze:
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

On Jan 30, 10:07*pm, evora... (AT) yahoo (DOT) ca wrote:
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