hello everybody. i was trying to restore a backedup database but i
encounter the problem below.need help please.thank you very much.
Jul 27 07:59:35 2005: Backup Server: 1.70.1.1: Configuring the maximum
shared memory usage to 48 MB.

I getting this message while I'm trying to queice RS
I have stopped rep agent in primary db
Can any one help
suspend log transfer from all

I'm trying to execute a procedure but get this messages:
Space available in the log segment has fallen critically low in
database 'tempdb'.  All future modifications to this database will be
suspended until the log is successfully dumped and space becomes

Hi,I would like to know if it's possible in Sybase to create store
proc with optional parameters.
Thank you

I am testing a SQL query on 2 "almost" identical databases. The SQL
query is made by a Java ORM framework (Hibernate), so I dont have too
much control over it. I know the query is very strange because it only
try to make a join between 2 primary key.

it's quite urgent.
Our ASE 11.5 does not allow any client to connect.
Also as : sa i cannot login using the isql command line
So a safe shutdown is not possible.

Which scenario should give better performance for Sybase 12.
1 production database with all tables, views etc (of cause there are
standard databases ones here as well).
Multiple production databases with exactly the same total number of

I'm migrating some Sybase databases to MSSQL server. In MSSQL the ROLE info
is stored in system tables in each user database where as in Sybase it's
stored in the master database.
What I'm looking for is a script that will query Sybase for each Role,

Please confirm what locks are acquired on system tables by the
following statements in ASE12.0
1. create table .
2. drop table.

please provide me ith the differnce between max memory,logical memory
and physical memory along with with their usages....
 am in urgent need kindly reply
also what is the relationship between max memory and shared memory

Please go through to give me some assistance
ASE 12.0 on HP-UX
Is there any way that we  can track the activities/usage of a
particular login. There is a login which is having a most  of  the

Is there a way we can export the table definition from an existing
database and then import them into another?

Hi NG,
I am fighting a connection problem and need help!
We are running the ASE 11.9.2 on a Suse Linux 8.2 box.
I want to write a little application on a linux platform that connects

ASE 12.0.0.4
SunOS 5.8
I've been evaluating our configuration as regards our current use of
database devices and segments and how to improve our performance, if

I almost did it but i miss it a bit.
I just want to concatenate 2 string and 1 numeric fields that way:
field 1, char 3: 671
field 2, char 5: FGD11