Recently the log on the sybsystemdb on one of our servers got filled. The following is the output of sp_helpdb "sybsystemdb" sp_helpdb...

kemy

09-29-2009 09:36 AM
kemy

If CIS setup is enabled and if loopback proc executed, do this(the CIS component) add to the network traffic? To try to be more clear - will...

dumb dog

09-25-2009 10:07 AM
Jeff Tallman [Sybase]

I am a developer trying to gain on admin skills. Any recommended books ? Thank you Yog

Yog

09-18-2009 11:50 AM
Rob V [ Sybase ]

I have a question about "max native threads per engine" on a "Sun T5240 UltraSPARC-T2+" Since the native thread and the LWP have a 1:1...

Alan Matlock

09-15-2009 07:35 AM
Jeff Tallman [Sybase]

Hi folks I created 300mb db 'for load' and started loading. It takes already 5hr and accumulated some cpu time. No blocking processes of any kind....

gene

09-08-2009 04:52 PM
Jason L. Froebe

Hi All Is that possible to specify cpu limit for the instance so 2 instances on the same server will not compete for it.

gene

09-07-2009 04:51 PM
gene

Hi how to use sysmon to monitor the 4k and 32k buffer cache that are defined on my server? thank you

Bob

09-06-2009 03:40 PM
Rob V [ Sybase ]

Hi, Does any one has any idea why crdate of sysindexes table shows NULL value for many indexes, while it should show either creation date, or index...

Matt

09-05-2009 05:00 AM
Matt

Required by policy to audit for weak/null passwords in Sybase. Does anyone know of a product that will do this for Sybase ASE? They are several...

ARob

09-04-2009 02:35 PM
ARob

Hi, I represent the Center for Internet Security. We are a non-profit organization that creates consensus security configuration guides. Our guides...

blakefrantz

09-02-2009 08:18 PM
blakefrantz

Can someone help me with this error? This is a new install on a Linux box. #!/usr/bin/csh setenv ERRORLOG MYSERVER_errorlog.`/bin/date...

Jamis

09-01-2009 11:19 AM
Sherlock, Kevin [TeamSybase]

Hi, On a 12.5.3 ESD 7 server, running on AIX 5.3 I have this message that crops up fairly often. "max online engines" is 4, but the number...

Michael Peppler [Team Sybase]

08-26-2009 11:57 PM
Michael Peppler [Team Sybase]

Hi Please share what do you use to monitor your ASE servers? thanks

Bo

08-26-2009 07:05 PM
rick_806

anyway to decrease the log level to just critical in ASE error log? thanks

Bo

08-25-2009 10:46 AM
Bo

Hi, I'm new to sybase adaptive server. Need help in moving content of a table from one server to another using isql. Both servers are running in sun...

dominicus

08-25-2009 02:37 AM
Leonid Gvirtz

I installed ASE 15.0.2 on a Solaris server We have some data with the Spanish tilda that is not displaying the tilda. 1> sp_configure "unicode" 2>...

KB

08-20-2009 03:27 PM
Neal Stack [Sybase]

Question: Is there a way of querying the system to determine the transaction isolation level of each user connection? Background: We are...

ahood

08-20-2009 12:58 PM
Sherlock, Kevin [TeamSybase]

Hi, The current process is infected with signal 11 (sigsev) and the sql causing error is update index statistics I am using 12.5.4. Is there any...

Dany

08-20-2009 10:06 AM
jeroen

Hi could you please send me some hints on how to read/decode stacktraces in log file? thanks

Bo

08-18-2009 11:17 PM
Manish Negandhi

Do you know how to read ase's syslogs table? It's very difficult for reading. "select * from syslogs" we can get only short messages of syslogs....

hobbylu@msn.com

08-18-2009 06:53 AM
hobbylu@msn.com

Question: Am I being irresponsible if I add user defined entries to the syscomments table to help me manage database objects? Background: The...

ahood

08-16-2009 01:16 AM
ThanksButNo

Sybase is definitely a good product, however, here are some long requested features Sybase needs to work on: 1. database shrink 2. backup on...

SybPro

08-14-2009 11:30 AM
Sherlock, Kevin [TeamSybase]

the instance in which the messages get written to is a logshipped instance. whenever a transaction log/database dump from the primary instance...

kemy

08-13-2009 04:42 PM
kemy

Hello. I have created a database repdef/subsription in the master database. This is for logins, roles, etc. Looks like everything works except...

reddyp

08-11-2009 01:43 PM
Sherlock, Kevin [TeamSybase]

I am getting error to add a temp group. 1> sp_tempdb 'create',sa_group 2> go Msg 18941, Level 16, State 1: Server 'appsdev2', Procedure...

dhanajeeM

08-10-2009 11:47 AM
dhanajeeM

Hi, I need to estimate the time that will take the load of my db. I'm working with Sybase ASE 12.5.x. Can you tell me how can I estimate the time...

Serge

08-10-2009 06:56 AM
Serge

AIX-64bit ASE 12.5.3 ASE 15.0.3 I have two log shipping processes: 1. 12.5.3 to 12.5.3 (logs load from que directory OK) 2. 12.5.3 to 15.0.3 (logs...

rick_806

08-08-2009 10:43 PM
rick_806

HI Folks, Anyone got any suggestions for how to deal with a situation where we've got a transaction and its locks still there when the spid (377) is...

John Craig

08-07-2009 03:46 AM
Rob V

Okay... tough question... at least tough to explain the question. We noticed that on our other Sybase ASE installations, the System Device only...

Becky Deland

08-06-2009 02:29 PM
John Flynn

I need to setup ASE with windows authentication, can someone direct me to the documentation on how to do that and does it require any specific...

HA

08-06-2009 11:41 AM
HA

Hi, If I setup a password policy, will it only affect logins that are created after tehg policy is set or will it afftect all existing logins on...

Germano Silva

08-03-2009 12:02 PM
Jeff Pryslak [Sybase]

Do you know how to read ase's syslogs table? It's very difficult for reading. "select * from syslogs" we can get only short messages of...

hobbylu

08-03-2009 09:51 AM
hobbylu

Do you know how to read ase's syslogs table? It's very difficult for reading. "select * from syslogs" we can get only short messages of...

hobbylu

08-03-2009 09:38 AM
hobbylu

Hi All, Can any one let me know whether the dump taken to File system is Valid or not .i.e How to check whether dump in UNIX box is usable or if it...

preetham

08-03-2009 06:49 AM
preetham

What type of locks is held by the following commands: - reorg reclaim_space tablename - reorg forwarded_rows tablename - reorg compact...

dumbdog

08-01-2009 09:06 AM
dumbdog

We have a production and a test server that both have ASE 12.5.4 running on AIX. A user wants to run some queries in am Access database that uses...

Audrey Won

07-31-2009 11:10 AM
Neal Stack [Sybase]

Hi, We have a case where a page in cache is corrupted (Error 624) but underlying table is unaffected (confirmed with dbcc tablecheck). Is there any...

Venkitachalam

07-31-2009 09:33 AM
Mark A. Parsons

Is it possible to get all temporary databases using one select statement? Thanks!

Mihalis Miliarakis

07-29-2009 05:33 AM
Mihalis Miliarakis

Hi, We have a case where a page in cache is corrupted but underlying table is unaffected (confirmed with dbcc tablecheck). Is there any way we can...

Venkitachalam

07-29-2009 03:01 AM
Venkitachalam

ASE 12.5.3-ebf12457, AIX 5.3.7.5 I need to move ASE 12.5.3 server to new machine. I don't find any references in the docs to moving a server so I...

rick_806

07-27-2009 08:17 AM
mpeppler@peppler.org [Team Sybase]

Hi! Can we have ldap and sql.ini work together to define ASE servers? thank you-

Marcel

07-23-2009 10:20 PM
Cory Sane [TeamSybase]

Hi, I wanted to know if there is any way to find out the date when a database was dumped or loaded for last time without checking backup.log file...

sumit.kd

07-22-2009 10:58 AM
preetham

Hello I was with the tech support who informed me two bad news: sqladv is not supported by sybase sqladv does not integrate with ldap to retreive...

Gerard

07-21-2009 11:47 PM
Cory Sane [TeamSybase]

Unfortunately I have an estate that includes everything from 15 back to 11.5. I've also got a servers that have non-default page-sizes. My problem is...

JW

07-21-2009 10:07 AM
JW

Hello All, I have a question on shared intent (sh_intent) lock. My understanding is that it is an indication that a shared page/row lock exists in...

Pradeep

07-20-2009 06:46 AM
Pradeep

Hi is there a way to check if sp_flushstats was executed on a db before the dump? for example, in logs or in the .dmp file? thank you

Gilles

07-17-2009 03:10 AM
Gilles

Hi, I worked on version Adaptive Server Enterprise/12.5.3/EBF 13325 ESD#7/P/Sun_svr4/OS 5.8/ ase1253/1951/64-bit/FBO/Fri Mar 24 11:00:22 2006 Due to...

Taylor

07-15-2009 10:45 AM
Sherlock, Kevin [TeamSybase]

Rajasekhar Reddy

07-14-2009 10:32 AM
Peter Collard

Hi, I know there are two ways to find out what sql is currently running. One is using monProcessSQLText, another is using dbcc sqltext command. I...

Taylor

07-13-2009 10:46 PM
Taylor

I am continually getting the following error message. Msg 12908, Level 16, State 1: Server '######_#####', Line 1: Index 2 of object 1072579455 has...

Shane

07-13-2009 10:20 PM
Shane