Hi, we're planning to implement SYBASE 12.5.3 with devices from SAN. What I want to know is wether there is a block size which is advantageous for...

Heinz Müller

08-02-2007 11:21 AM
Heinz Müller

Sybase doc's at: http://download.sybase.com/pub/ase1254esd4/New_features_1254_esd4.pdf talk about a new "huge page" feature: So this sounds like...

bslade

07-31-2007 03:02 PM
bslade

Hi :) I'm using ASE 15.0 My default Character set is Cp1251. In my DataBase there are more that 1000 Java class files. In some of them I must...

Stoyan Minchev

07-31-2007 01:37 AM
Stoyan Minchev

1- segments and devices, give me some pratical examples why we needs both and what is signifigant to have segments? I don't get it yet. I am Oracle...

soalvajavab1@yahoo.com

07-30-2007 11:55 PM
Renzo.aquino@gmail.com

Folks: Anybody has a SQL Script which will reorg rebuild all tables on all databases on the server/instance?

dba_newbie

07-30-2007 10:15 AM
Thierry

Anyone? On Jul 23, 5:27 pm, deanjon... (AT) gmail (DOT) com wrote:

deanjones7@gmail.com

07-25-2007 07:13 PM
deanjones7@gmail.com

Hi, is there any way where in we can find segment space utilization of log segment or any other segment?

Ambar

07-25-2007 06:27 PM
Mark A. Parsons

Have a question in CURSOR. I am trying to drop this list of devices: select name from sysdevices where phyname LIKE "%disk2%" go sp_dropdevice...

melanie

07-25-2007 06:17 PM
Arvind Bhanushali

Hi, I know that there is an alternative kill command in SYBASE but I can't remember the name. It's not syb_terminate! SYBASE 12.5.3 Any help would...

Heinz Müller

07-25-2007 05:53 PM
Bret Halford

Sybase Gurus, Could one of you give me the command to BCP out a complete Sybase DB into a flat file. The DB size is just 1GB+. Thanks in...

sqlsrini@gmail.com

07-25-2007 06:22 AM
margaret@mcobtechnology.com

Hi All, While executing this command I am getting below error? update index statistics TABLE_NAME DBD::Sybase::st fetchrow_array failed:...

Nishant Rupani

07-25-2007 12:29 AM
Nishant Rupani

Gurus, We are planning to implement an EMC SRDF between our Production and DR (Disaster Recovery / Fallback server) Sybase server, I just wanted...

sqlsrini@gmail.com

07-24-2007 11:21 PM
sqlsrini@gmail.com

Hello, 1) If : - I want to use only unserved licenses - I have 4 hosts and 16 ASE servers and I want to be able to run each ASE on each host where...

Luc Van der Veurst

07-24-2007 10:11 PM
Mark K

how do you spool in isql like oracle spool? possible? how do you repeat the last command in isql? possible? what are the some frequently use...

soalvajavab1@yahoo.com

07-24-2007 01:46 PM
soalvajavab1@yahoo.com

Hi, I had a strange experience. We had to rename a server and also move it to another file system. I updated the system tables sysdevices...

Etienne

07-24-2007 05:14 AM
Etienne.

in Isql how can u repeat last command? is there anyway tonot say go sometimes for example type use mydb sp_helpdb and then type go for both instead...

soalvajavab1@yahoo.com

07-23-2007 06:40 PM
Mark A. Parsons

I work as DBA in a small group of ASE developer. There are seven developers including me. My question is: Is there a best practice for setting up...

Shawn

07-23-2007 09:22 AM
Shawn

Folks: Any Idea how to delete a JOB in Sybase. When I try to delete it using Sybase Central.. It gives me the following error: Procedure...

Sybase DBA - Newbie

07-22-2007 11:20 PM
Jaikishan

Anybody using Sybase for Windows and have a script which will get all the database names from sysdatabases and then backup the databases to a device.

Newbie - Sybase for Windows

07-22-2007 06:38 AM
Emmanuel Torre

I am on a 12.5 server, unix, sun solaris and run a select statement on two tables: Balance: with 326,835 rows and a clustered index Position with...

Tartampion

07-20-2007 01:16 PM
Sherlock, Kevin

Hi Friends, We are planning to upgrade replication server from version 12.1 to 15.0 Is there any document available related to that. What is the...

SC

07-20-2007 11:25 AM
Arvind Bhanushali

Hi all, I wanna to install another server "B_SERVER" with backup server on my ASE12.5.1 box, it was already installed a server "A_SERVER"...

STandard

07-20-2007 11:05 AM
Arvind Bhanushali

hi there, I have a problem with dbcc here. there is a database around 45G ( not too big, is it), a few big tables, 10G, 8G, 3G,etc, others are...

DBA_M

07-20-2007 08:01 AM
Etienne

Hi All, I encountered with a fact that ASE allows to configure multiple checkpoint process for faster recovery. One case study that I got says that...

Nishant Rupani

07-20-2007 02:27 AM
Nishant Rupani

Does t-sql insert , update, etc. needs commit statment like oracle or not? how can you run an test.sql script from isql session? is there spool...

soalvajavab1@yahoo.com

07-19-2007 11:53 PM
Michael Peppler

Hi sybase admins, ASE 12.5.3 ESD6 I have a table (fillfactor 100%) on which the dbcc checkstorage raises a big bunch of 100037 erros that are...

Emmanuel Torre

07-19-2007 08:12 PM
Mark A. Parsons

Hi All, I encountered with a fact that ASE allows to configure multiple checkpoint process for faster recovery. One case study that I got says that...

Nishant Rupani

07-19-2007 01:40 AM
Nishant Rupani

How to reduce the database size? I have a senario where in Iam migrating a database from ONE (old) server to another (NEW). Current database size is...

upmirji

07-19-2007 12:38 AM
UPMirji

There is a message about optimal number of recovery processes in the ASE log at startup. How is this calculate and are there any configuration...

Richard Kinread

07-18-2007 07:01 AM
Mark K

the backup server hangs frequently on ASE12.5.4 ESD3 on x86 platform: ################## Open Server Error: 16124.10.0: Cannot create...

melanie

07-17-2007 09:22 AM
Brad Plumlee

hi When the select command is executed, I see this in sp_who: 0 63 lock sleep dbuser dbuser user1 0 DB1 SELECT ...

melanie

07-17-2007 01:32 AM
melanie

Hi, While looking for free space in my database devices I realized that I have this 50MB database device called pcdev that I don't remember...

Germano

07-16-2007 05:04 PM
Carl Kayser

we received stack trace on PROD server and as per sybase that was because of corrupted stored procedure. Is there anyway to find out such corrupted...

Tammy

07-13-2007 07:02 PM
A Cornell

Hello, Please dismiss this email if it is not the appropriate forum. This is a personal and informal message and has not been sent on behalf of...

fernando.amores@bluewin.ch

07-13-2007 05:10 AM
fernando.amores@bluewin.ch

I am trying to change the default char set on my sybase ASE 12.5.2 (Adaptive Server Enterprise/12.5.2/EBF 11799/P/Linux Intel/Enterprise...

L.S.Dhar

07-12-2007 08:28 AM
LSDhar

I have a database that has several devices. when I run my query it takes a lot of time, with high io activity is there a way to correlate this...

Neo

07-12-2007 06:37 AM
Rob Verschoor

what's steps I have to follow to move the trans logs from one device to another. appreciuate if you provide me the scripts and steps.

soalvajavab1@yahoo.com

07-12-2007 05:53 AM
Bhushan

I need to load two diffrent Db on a Netware 6.5 server. Each has diffrent load parameters. I see how to load the Dbs but not how to specify...

Bill Drummond

07-11-2007 06:30 AM
Mark A. Parsons

Jason L. Froebe wrote: (snipped most of Rob's reply) Hi Jason, Okay, just to clarify, my sys admin used tmpfs to create the space for tempdb. I...

Larry Coon

07-09-2007 08:10 PM
Larry Coon

before running this command: exec sp_serveroption "SYB_BACKUP", "negotiated logins", "true" I'd like to know what is the current value of...

melanie

07-07-2007 05:28 PM
Emmanuel Torre

Guys, for a lab test on a solaris 1502 server, I dumped then tried to do an archive load of a database. the database was 198GB. The dump reported...

Cory

07-07-2007 05:22 PM
Emmanuel Torre

FREE monitoring tool for SYBASE www.dbainformer.com DBA Informer for SYBASE allows you to see: 1. All running processes - by clicking on a process...

Gregory Surilov

07-06-2007 02:24 PM
Gregory Surilov

Pardon for newbie questions: when we usually get tempdb full and what is the primary remedy and what is the long term solution? when we usually get...

soalvajavab1@yahoo.com

07-06-2007 02:00 PM
Marc Zampetti

Stored procedure '*00038300000000_49bd17' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session...

MS

07-06-2007 10:31 AM
MS

Hi All, I want to put quotes around the column value with the help of Function ONLY. Eg Old value Required Value Boston --> ...

SK

07-03-2007 02:12 PM
Michael Peppler

I am planning to move all databases from one storage to another. I am planning to use Mirroring the devices & break the mirror. My current devices...

Ambar

07-03-2007 06:38 AM
A. M.

Nice to have feature: create database UAT1 ON MYDEV1=### LOG ON MYLOG1=### USING myPROD SCHEMA Benefit: -- You don't have to drop and create -- you...

Eddie_A

07-03-2007 12:39 AM
mpeppler@peppler.org

Hi Guru, Is there any query/way where we can find out the amount of space used by login ids or queries while executing join /sort /group by...

bob

07-02-2007 11:52 AM
AmVar

For wat purpose ? Failover ? Yes Simultaneous use ? No Luc.

Luc Van der Veurst

07-02-2007 07:43 AM
Luc Van der Veurst

I am running one query, result of which is redirected to another file, which runs to fetch the final result, Problem is with result of first query,...

Jack

06-29-2007 07:00 AM
A. M.