Hello,
We are using MSA bi-directional replication between 2 ASE servers (15.7) and 2 repservers (15.7) (via a route between the repservers) at 4 of our partners and have 6 of those pairs in house. That works fine.
For a new setup we are using re...
Hello,
ASE 15.7 sp140, Repserver 1571 sp302.
I'm puzzled :). We've setup database replication for many times, and now for a new setup, I encounter a problem I've never seen before. We have a table thas has an in row (3700) text column, nulls not ...
Hi,I saw that I didn't have messages from the SAP discussion groups for a week and found out that platform became obsolete. I haven't seen an improvement yet, but just started looking at it. First thing is: how do I get my email notifations back?Than...
Hello,I have noticed that the behaviour of textptr has been changed between ASE versions sp122 and sp135.If you have a tablecreate table tt(i int, j text null)and insert a null value for tinsert tt(1, null)and then executeselect textptr(j) from ttthe...
Hello,Our application is getting a lot of the following errors :Caused by:com.sybase.jdbc4.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException:Error occurred while executing batch statement: The dynamic statement'*sh1731692265_0874276115ss*' co...
Hello,You can not stop logging since it's necessary to maintain the integrity of a database in case of a roll back of a transaction or a crash of the dataserver.Yes, you can turn full logging for all off without restarting the server.It will only hav...
Hi Andrew,What setup.bin first tries to do is check if it should run in graphical or console mode.In what kind of environment is your shell running? Some windowing system?Is the environment variable $DISPLAY set?If so, unset it and try again.It's jus...
Hi Dilip,I'm not aware of a procedure to backup and restore cached statements.But what you can do is using dbcc prsqlcache(id, 0) to show the query and dbcc prsqlcache(id, 1) to show the query plan of the cached statement with the ids you found in mo...
Hi Mark,No, no problem, it wouldn't be the first time I forget something :-).I opened a case with SAP.The behaviour of dsi_replication_ddl has changed, this had become:1. “dsi_replication” use to control both DML and DDL applied by DSI, whether can b...
Hi Mark,Thanks for your reply.Setting dsi_replication_ddl to 'on' is part of our script that also executes rs_init to add a connection.I verified the setting running admin config, connection, to verifiy that it is indeed set to 'on':$ rep_admin_conf...