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

On Jan 30, 10:07 pm, evora...@xxxxxxxx wrote:
On Jan 30, 6:26 am, mnajs <marc...@xxxxxxxxxx> wrote:



evora...@xxxxxxxx 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.

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
.

Relevant Pages

  • Re: How to change ASE page size from 2k to 8k
    ... Unfortenately the tool gives all kinds or errors out when i invoke ... library error: Failed when CT_Lib routine ct_resultscalled.'. ... client and server character sets. ...
    (comp.databases.sybase)
  • Re: Client callback adding items to databound collection = crossthread error
    ... // the server ... // SynchronizationContext earlier in the service's Ctor, ... My client passes an EventShim with a callback to the server. ... How do I invoke a delegate on the UI thread without having ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Executing a program on the AS400 from VBSCRIPT
    ... procedure support to invoke your program. ... PROCEDURE statement from SQL/400 or from any client that supports SQL ... There wouldn't be anyway to get return codes back from the execute ...
    (comp.sys.ibm.as400.misc)
  • Http error 413->Request entity too large
    ... I have a webservice under IIS6/Win2003 Server. ... When I try to invoke a method ... I mention that this dataset is very large and if the client ... I checked the settings in machine.config file and the atributte for ...
    (microsoft.public.dotnet.framework.remoting)
  • Http error 413-> Request entity too large
    ... I have a webservice under IIS6/Win2003 Server. ... When I try to invoke a method ... I mention that this dataset is very large and if the client ... I checked the settings in machine.config file and the atributte for ...
    (microsoft.public.dotnet.framework.adonet)