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 159
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...
Shreya
04-25-2007 10:26 AM
Shreya Go to last post
12 527
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...
Sandy
04-24-2007 10:49 PM
Sandy Go to last post
2 134
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 462
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...
crystal.jordan@dys.ohio.gov
04-21-2007 01:32 AM
A. M. Go to last post
3 418
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...
Shreya
04-20-2007 08:29 AM
Shreya Go to last post
2 104
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 117
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...
soalvajavab1@yahoo.com
04-19-2007 12:45 AM
mpeppler@peppler.org Go to last post
2 114
Hello, we have server ASE 11.9.2.5, it is in cp852 charset coding (Central Europian). I need to use client coding utf8. when I run set char_convert...
jaroslav.povolny@gmail.com
04-18-2007 12:50 PM
Eugene Korolkov Go to last post
2 104
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...
soalvajavab1@yahoo.com
04-18-2007 11:43 AM
Sherlock, Kevin Go to last post
1 93
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...
Lal
04-16-2007 03:23 PM
Lal Go to last post
3 313
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
Toni
04-16-2007 01:04 PM
BS Go to last post
2 152
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?
soalvajavab1@yahoo.com
04-16-2007 10:46 AM
Sherlock, Kevin Go to last post
4 451
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 ?...
jw
04-11-2007 11:28 PM
Mark A. Parsons Go to last post
4 143
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...
evoradba@yahoo.ca
04-11-2007 04:52 PM
Heinz Müller Go to last post
8 207
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...
Hiten
04-11-2007 01:07 PM
Don Million Go to last post
2 879
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 537
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...
paul.mcgrane@luht.scot.nhs.uk
04-08-2007 12:11 AM
A. M. Go to last post
9 131
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...
melanie
04-07-2007 10:17 PM
A. M. Go to last post
8 178
HI im running select count(*) on sysaudits_01 (sybsecurity)ASE 15 on Windows This process has been hung by AUDIT PROCESS. Auditing has been...
RajShekar
04-07-2007 10:06 PM
A. M. Go to last post
3 103
Dear DBAérs, I am not very experienced in my DBA work for Sybase database3s. Anyway I have problems replicating several local sql advantage...
SalsaFreak
04-06-2007 02:39 PM
Tommy Phillips Go to last post
1 113
Error: 8204, Severity: 20, State: 4 server Expected to receive system catalog id. Instead 8 was received.
melanie
04-06-2007 04:41 AM
melanie Go to last post
3 93
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...
melanie
04-05-2007 08:24 AM
Derek Asirvadem Go to last post
4 172
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 184
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...
Bob
04-05-2007 03:10 AM
BOB Go to last post
2 387
is there a way to stop these kind of messages from ASE: CREATE DATABASE: allocating rrrrrr logical pages (ttttt megabytes) on disk 'xxxxx'
melanie
04-04-2007 05:21 AM
mpeppler@peppler.org Go to last post
1 95
ASE is up (server and backup). however, all spids are not progressing. nothing shown in log since 2 days. how to troubleshoot similar situations?
melanie
04-04-2007 05:19 AM
mpeppler@peppler.org Go to last post
1 95
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...
melanie
04-03-2007 11:43 AM
Bret Halford Go to last post
3 94
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 514
I am quoting from this document: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20020_1251/html/databases/X24263.htm "Free space...
melanie
04-02-2007 09:35 AM
Derek Asirvadem Go to last post
8 114
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...
Lyle
03-31-2007 07:01 AM
Vishi Go to last post
8 129
most of the deadlocks we encounter are between index pages. Is this a valid reason to switch to DOL scheme?
melanie
03-30-2007 12:51 PM
ahood Go to last post
2 85
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,
melanie
03-30-2007 12:48 PM
ahood Go to last post
1 87
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...
nuri
03-29-2007 02:48 AM
nuri Go to last post
2 85
to kill a dump or a load, i have to restart the backup server. kill does not do the job. any alternatives?
melanie
03-28-2007 12:09 PM
Don Million Go to last post
3 147
can we take the session out of that user?
melanie
03-27-2007 12:14 PM
Bret Halford Go to last post
1 98
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...
make8@technologist.com
03-27-2007 08:09 AM
Henry Go to last post
4 120
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...
jw
03-27-2007 04:19 AM
Luc Van der Veurst Go to last post
1 92
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 125
sp_spaceused <table_name> name rowtotal reserved data index_size unused -------------------- -----------...
melanie
03-26-2007 03:07 PM
Henry Go to last post
1 106
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...
melanie
03-26-2007 04:25 AM
Derek Asirvadem Go to last post
3 143
how to see if a table is partitioned?? thanks.
melanie
03-26-2007 02:20 AM
melanie Go to last post
1 122
Hi, I still don't see the difference between -options-template <responseFileName> and -options-record <responseFileName>. Can some1 help and...
melanie
03-23-2007 05:19 PM
Rhod Go to last post
2 90
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...
melanie
03-23-2007 11:53 AM
Will Banta Go to last post
6 109
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?
melanie
03-22-2007 05:20 AM
A. M. Go to last post
7 138
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 246
is it possible to have 3 fragments of the db on the same database? how is that?
melanie
03-21-2007 09:59 AM
Will Banta Go to last post
3 103
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?
melanie
03-21-2007 09:03 AM
Will Banta Go to last post
1 98
Hi I am looking for an automatic installation (which is available) and automatic configuration (srvbuild) and upgrade. can we configure a 'silent...
melanie
03-21-2007 07:26 AM
Neal Stack Go to last post
6 100
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.
melanie
03-20-2007 08:13 AM
melanie Go to last post
2 110
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 - 2014, Jelsoft Enterprises Ltd.