dbTalk Databases Forums  

Sponsored Links

sybase.public.ase.administration sybase.public.ase.administration

Discuss in the sybase.public.ase.administration forum.

Post New Thread
Threads in Forum : sybase.public.ase.administration Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Good Day We run a script every night containing "exec UpdateStatistics". This script works mostly fine... .... an error appears randomly about...
Oliver Meister
04-26-2007 06:03 AM
Mark K Go to last post
1 172
Hi, Is there any other way of clearing the data cache (without bouncing or binding objects to the cache)?. Performance testers are trying to time...
04-25-2007 10:26 AM
Shreya Go to last post
12 576
We have configured memdump for Error 712. While configuring the same, we specified direcory name in sp_shmdumpconfig command but we didn't create the...
04-24-2007 10:49 PM
Sandy Go to last post
2 152
I have recently come across a problem when using tempdb as the default database for Sybase logins. The reason we use tempdb was so that master...
dave watts
04-23-2007 07:50 AM
Michael Heaney Go to last post
8 499
I have 2 servers and I wish to apply the values of one servers configuration file to the other server. Is it a safe practice to make a copy, rename...
04-21-2007 01:32 AM
A. M. Go to last post
3 437
Hi, I recently took bench mark timings for reorg rebuild on a big table on a development machine(refresh the data from production). It took 3 hrs to...
04-20-2007 08:29 AM
Shreya Go to last post
2 162
For some strange reason sp_sysmon on one of our ASE servers are not displaying the Open Object Usage under Metadata Cache Management. I have tried...
Sindre Holdahl
04-19-2007 04:22 AM
mpeppler@peppler.org Go to last post
1 134
Bunch of questions, sorry if ask too much but please help if you can, appreciated: How to measure the latency between subscribers and publisher? Can...
04-19-2007 12:45 AM
mpeppler@peppler.org Go to last post
2 127
Hello, we have server ASE, it is in cp852 charset coding (Central Europian). I need to use client coding utf8. when I run set char_convert...
04-18-2007 12:50 PM
Eugene Korolkov Go to last post
2 115
Required the outilens and commands step by step to setup rep server for 3 primary DB without sybase centeral. From command line. Your help is greatly...
04-18-2007 11:43 AM
Sherlock, Kevin Go to last post
1 102
How can I find out the out the Queue Latency in Sybase replication server .I ran admin,sqm and its very difficult for me to understand since I am new...
04-16-2007 03:23 PM
Lal Go to last post
3 329
Hi, We are using ase 12.5.3 on unix. How can we audit sa roles with the administration task such as drop, add user... dump database ... thanks, toni
04-16-2007 01:04 PM
BS Go to last post
2 159
Need clear steps for setting up the Rep Server 10.5 in Solaris machine? Can you please share with me your notes if you have done it before?
04-16-2007 10:46 AM
Sherlock, Kevin Go to last post
4 463
We are planning to upgrade ASE from 12.5.1 to 12.5.3. Where i can get the proper documentation for this.? does anybody have this documentation ?...
04-11-2007 11:28 PM
Mark A. Parsons Go to last post
4 153
hello I have sybase running on a veritas VCS and while using a script to shutdown ASE it hangs, meanwhile if using the same script to stop sybase...
04-11-2007 04:52 PM
Heinz Müller Go to last post
8 254
Getting following error... I just installed the server and in create server, I have provided/allocated double size to each devices and db it creates...
04-11-2007 01:07 PM
Don Million Go to last post
2 942
Hi all I have 530 indexes in my server and looking ways to remove useless ones. Can you please suggest the way to find our unused indexes without...
Nishant Rupani
04-10-2007 05:55 AM
Derek Asirvadem Go to last post
6 553
Currently running 11.9.2 ASE and the allocated space in the devices ran out. New devices were added and they were incorporated into the...
04-08-2007 12:11 AM
A. M. Go to last post
9 168
what is the prec, length and scale fields in sp_help? length is for char and varchar only? prec is for floats and indicates the number of digits...
04-07-2007 10:17 PM
A. M. Go to last post
8 216
HI im running select count(*) on sysaudits_01 (sybsecurity)ASE 15 on Windows This process has been hung by AUDIT PROCESS. Auditing has been...
04-07-2007 10:06 PM
A. M. Go to last post
3 112
Dear DBAérs, I am not very experienced in my DBA work for Sybase database3s. Anyway I have problems replicating several local sql advantage...
04-06-2007 02:39 PM
Tommy Phillips Go to last post
1 116
Error: 8204, Severity: 20, State: 4 server Expected to receive system catalog id. Instead 8 was received.
04-06-2007 04:41 AM
melanie Go to last post
3 101
where can we have the description of possible status a db can have (select status from sysdatabases)?? So far, 320 means a suspect status. What...
04-05-2007 08:24 AM
Derek Asirvadem Go to last post
4 182
Could anyone tell about the procedure , if the tempdb get full in production system? ( Apart from bouncing the server )
Bal Kumar
04-05-2007 08:22 AM
Derek Asirvadem Go to last post
10 200
Hi all We have audit data archiving job which selecting the data from syssecurity audit tables and inserting into one of our user db auddata. the...
04-05-2007 03:10 AM
BOB Go to last post
2 398
is there a way to stop these kind of messages from ASE: CREATE DATABASE: allocating rrrrrr logical pages (ttttt megabytes) on disk 'xxxxx'
04-04-2007 05:21 AM
mpeppler@peppler.org Go to last post
1 98
ASE is up (server and backup). however, all spids are not progressing. nothing shown in log since 2 days. how to troubleshoot similar situations?
04-04-2007 05:19 AM
mpeppler@peppler.org Go to last post
1 101
sometimes drop or load cannot be completed because for ASE there are user connections to the db. whereas in reality, no one is connected. is there a...
04-03-2007 11:43 AM
Bret Halford Go to last post
3 109
What does the output from this comamnd refer to? Is it proc buffers or proc headers or pages? What does Num_reuse refer to as well? How do you tell...
Richard Kinread
04-03-2007 06:44 AM
Derek Asirvadem Go to last post
14 561
I am quoting from this document: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20020_1251/html/databases/X24263.htm "Free space...
04-02-2007 09:35 AM
Derek Asirvadem Go to last post
8 132
We changed our OS to the new DST, but the database is still on the old time. Is there a way to reset the time in the database so it reflects the...
03-31-2007 07:01 AM
Vishi Go to last post
8 142
most of the deadlocks we encounter are between index pages. Is this a valid reason to switch to DOL scheme?
03-30-2007 12:51 PM
ahood Go to last post
2 89
does switching from all-pages to dol increase the space used by the tables? i.e. the storage becomes bigger? or does it reduce?? thx,
03-30-2007 12:48 PM
ahood Go to last post
1 91
Hi, I need to configure SSL feature at version ASE 12.5.4 ESD#4 on platform 64 bit RH 4.0. I configured with ASE's own certificate property by...
03-29-2007 02:48 AM
nuri Go to last post
2 93
to kill a dump or a load, i have to restart the backup server. kill does not do the job. any alternatives?
03-28-2007 12:09 PM
Don Million Go to last post
3 157
can we take the session out of that user?
03-27-2007 12:14 PM
Bret Halford Go to last post
1 140
Two questions: 1. In sybooks - It says "Install the new server into its own installation directory. You must have both the old installation and the...
03-27-2007 08:09 AM
Henry Go to last post
4 132
Hi We are planning to install Sybase ASE 12.5.3 on the HP unix server which is already having sybase ASE 11.5 installed.I have to install 12.5.3 on...
03-27-2007 04:19 AM
Luc Van der Veurst Go to last post
1 94
Adaptive Server Enterprise/12.5.3/EBF 13198 ESD#6/P/RS6000/AIX 4.3.3/ase1253/1945/32-bit/FBO/Fri Jan 20 02:50:56 2006 If I run the following query...
Larry Coon
03-26-2007 03:17 PM
Larry Coon Go to last post
2 153
sp_spaceused <table_name> name rowtotal reserved data index_size unused -------------------- -----------...
03-26-2007 03:07 PM
Henry Go to last post
1 113
this is to continue the last thread since the posting I made did not came at the end: I am quoting from docs: "Changing from datapages locking to...
03-26-2007 04:25 AM
Derek Asirvadem Go to last post
3 153
how to see if a table is partitioned?? thanks.
03-26-2007 02:20 AM
melanie Go to last post
1 126
Hi, I still don't see the difference between -options-template <responseFileName> and -options-record <responseFileName>. Can some1 help and...
03-23-2007 05:19 PM
Rhod Go to last post
2 101
hi deadlocks occurs often on some tables that has a lock scheme allpages. changing the lock scheme to DOL on these tables only can solve this...
03-23-2007 11:53 AM
Will Banta Go to last post
6 121
i altered the db to include 1 gb. however the fragment was created "data and log". what should have i done to create a 'data only' fragment?
03-22-2007 05:20 AM
A. M. Go to last post
7 152
Hi, how can I find out if a user in syslogins has referential integrities to other tables and if they have to print all this tables? What we want...
Heinz Müller
03-21-2007 07:27 PM
Derek Asirvadem Go to last post
14 296
is it possible to have 3 fragments of the db on the same database? how is that?
03-21-2007 09:59 AM
Will Banta Go to last post
3 111
I added 2 gb log on a device for a db. is there a way to drop these 2 gb without dropping the whole db?
03-21-2007 09:03 AM
Will Banta Go to last post
1 102
Hi I am looking for an automatic installation (which is available) and automatic configuration (srvbuild) and upgrade. can we configure a 'silent...
03-21-2007 07:26 AM
Neal Stack Go to last post
6 108
I went to http://downloads.sybase.com and logged in. But couldn't see but EBFs...can some1 please point to me the binaries to x86? thanks.
03-20-2007 08:13 AM
melanie Go to last post
2 117
Post New Thread

Display Options
Showing threads 901 to 950 of 1821
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.