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     
Respected , sir, My database working properly. I want to conform query related to transaction_log in master database. I always take master database...
07-28-2008 07:25 PM
A. M. Go to last post
30 412
I have executed a select statement, i got the below error message. Server Message: Number 3626, Severity 17 Server 'DEV', Line 1: The transaction...
07-28-2008 11:01 AM
Sherlock, Kevin Go to last post
60 836
Dear all, We have recently looked into buying Replication Server, but potentially have decided not to move forward. We are looking into ASE...
Susan Mills
07-27-2008 11:20 AM
Derek Asirvadem Go to last post
120 1,151
Hello, I'm an newbie with Sybase database. I have a version 12.5 sybase database i am trying to load on a test machine. I"m a complete idiot with...
07-25-2008 10:01 PM
Sherlock, Kevin Go to last post
110 892
we are using ssremote to replicate between to ASE 12.5.3 solaris servers, ssremote to truncating varchar(1500) fields to 255 characters. Is there a...
A Cornell
07-25-2008 04:20 PM
Bret Halford Go to last post
30 478
Where can I locate any documentation on moving a databases segments to new devices? Im on ASE 15.0.2.
07-25-2008 04:00 PM
Bret Halford Go to last post
10 203
I am a complete newbie to sybase (I'm really a microsoft sql server admin who just got a sybase db to admin). We had sybase running on one linux...
07-25-2008 01:30 AM
ThanksButNo Go to last post
60 649
The number of open objects keeps increasing whenever I try to find out and increase it accordingly. When should it stop reusing descriptors? How to...
07-24-2008 05:53 PM
Mark A. Parsons Go to last post
60 988
how to reset values displayed by monitorconfig without rebooting the ASE server?
07-22-2008 09:53 PM
Manish Negandhi Go to last post
10 282
bcp error (Multi-page thread 1 2 )
Hi, Target: ASE 12.5.3 Destination. ASE 15.0.2 with latest EBF I need to "bcp in" syslogins from Target to Destination but it fails...
Heinz Müller
07-21-2008 10:24 AM
Bret Halford Go to last post
10 338
Hi Michelle-- Thanks for the information. I followed it for the second suggestion but I still cannot start up sybase server. Do I need to...
07-18-2008 03:20 PM
Sherlock, Kevin Go to last post
10 354
I get the following message after I load a db backup from a 12.5.2 ASE server to a 12.5.4 on a W2K3 box: Backup Server: LOAD is complete...
Mike G
07-18-2008 01:30 PM
Mike G Go to last post
20 262
On our Sybase 12.5.2, the public group has 'select' permission on many tables and 'exeucute' permission on procs. This has been identified as...
Audrey Won
07-18-2008 01:22 PM
Audrey Won Go to last post
30 482
Trying to upgrade from 12.5.1 to 12.5.4, and instructions say to check existing database first. Well that sounds like a good idea. select...
07-15-2008 08:21 PM
ThanksButNo Go to last post
20 570
Can anyone tell me the adavntage or disadvantages of using user roles over database groups for user permissioning
07-15-2008 11:51 AM
bslade Go to last post
60 929
Hi guys, Is there any way to correctly estimate time for the creation of clustered index by primary key constraint. thanks
07-14-2008 08:17 AM
Manish Negandhi Go to last post
10 197
if i load a db which is being replicated into another database which is not replicated and do not remove the sec trun point and say in loaded db: -...
07-10-2008 03:32 PM
Bret Halford Go to last post
9 97
Hi, Iam Using ASE 12.0 on solaris 10. On my production system create index on a particular table is taking very long time /hanging. Same script...
07-09-2008 09:40 PM
ThanksButNo Go to last post
20 337
We recently got a large number of dbcc 15052 , we fixed the issue however they keep reappearing , they seem to be spurious , has any one else had...
07-08-2008 10:50 AM
Bret Halford Go to last post
10 343
mdcache (Multi-page thread 1 2 )
Hi guys, My question is a little theoretical than practical. I was looking forward to tuning my meta data cache. But I couldn't figure out how DBINFO...
07-07-2008 12:12 PM
Bret Halford Go to last post
10 375
Hi guys, I have a server machine that runs 6 sybase instances, all instances starts correctly when server starts except 1 instance. When i...
Ramez Nabil
07-07-2008 12:08 PM
Bret Halford Go to last post
20 306
for the error message Error: 1204 there are different states 1, 2 etc, can someone please point me to a link or explain what the different states...
07-02-2008 06:31 PM
dev Go to last post
30 499
monProcessSQLText shows the procedure which is run by a spid, it does not show the parameters which are passed to the proc. Any trick to see the full...
06-29-2008 02:21 PM
Mark A. Parsons Go to last post
30 457
Hi guys, Is there function to get the number after a decimal point? ex: 6.500 I need to get the 500 only Thanks in advance
Ramez Nabil
06-27-2008 05:01 PM
Mark A. Parsons Go to last post
10 197
Howdie all! I need to implement some kind of banner in Sybase 12.5.3 to indicate that the database is "For Official Use Only". Is there a way to...
06-26-2008 01:21 PM
peter collard Go to last post
10 200
Hi All, For last several months, we are facing issues where SPIDs are stuck in the "sync sleep" status and remains there forever or for very...
Nishant Rupani
06-26-2008 12:31 PM
Manish Negandhi Go to last post
80 1,110
The initial locking scheme of a table was allpages locking. The table has a clustered index on 5 columns and there are separate non clustered indexes...
06-25-2008 05:12 PM
peter collard Go to last post
40 414
Hello all. I created an abstract plan for a query dinamically generated by a tool and it's working when I execute the showplan. I created the AP...
ST - Forum Sybase
06-20-2008 07:39 AM
Sergi Go to last post
40 730
The log segment in database 'PFA' contains 486290 misplaced data extents of which 0 of them do not belong to any object. how can i resolve this issue
Opawole Biyi
06-20-2008 05:47 AM
Jaya Go to last post
10 226
I have a database that's sitting in "load" state waiting for transaction dumps to be loaded. I have a stack of transaction dumps waiting to load. I...
06-19-2008 11:10 PM
ThanksButNo Go to last post
30 638
After loading my database ,any attempt to online the database i keep getting the error below : Illegal attempt to clean buffer: BUF pointer =...
Opawole Biyi
06-18-2008 09:48 PM
Opawole Biyi Go to last post
40 656
Is it better to run the dbcc before a reorg on a database (table)or visa versa?and why?
06-18-2008 12:39 PM
Bret Halford Go to last post
20 521
ASE 12.5 (Multi-page thread 1 2 )
'There is insufficient system memory to continue login process for spid 91' pls can someone help me i can login to my ASE12.5 again it keep giving...
Opawole Biyi
06-18-2008 01:59 AM
Manish Negandhi Go to last post
10 181
Hi everybody, I've encountered a weird problem, hoping that someone could help me out. I have a table with schema like...
06-16-2008 10:52 AM
Bret Halford Go to last post
30 312
Hi there, Anyone know how to repopulate master..sysroles if is accidentally deleted ? There is a bcp file containing all the info required to...
06-13-2008 10:44 AM
Sherlock, Kevin Go to last post
10 301
is there any benifit of using 4k page size over 2k on solaris for ase 15.0.2?
06-13-2008 03:38 AM
peter collard Go to last post
100 847
Hi, I've the following error when i try to load a compressed dump file that was dumped from another server than the one i load on: Backup Server:...
Ramez Nabil
06-12-2008 10:26 PM
Cory Sane Go to last post
40 650
Using LDAP (Multi-page thread 1 2 3 )
Is additional license needed to use LDAP? Could someone list some pros and cons of using LDAP? What will happen to syslogins (create user, delete...
06-11-2008 09:20 AM
Motif Go to last post
20 399
Please forgive me if this is a dumb questions... When using sp_addserver... if we have two Sybase instances on the same box / server... would one be...
Susan Mills
06-10-2008 09:23 PM
Susan Mills Go to last post
70 848
if i have a "user1" who creates a table in tempdb and now the "sa" login wants to drop/clean the table from tempdb without rebooting the...
06-10-2008 11:06 AM
Sherlock, Kevin Go to last post
40 634
lock (Multi-page thread 1 2 )
A user is holding locks on the order table: fid spid loid locktype table_id page row dbname class context ------...
06-09-2008 11:56 PM
Manish Negandhi Go to last post
10 235
Hi, After some advice re the following tuning experience. We have ordinary online response and ok batch with ONE 1600mg 2k pool in the data cache. I...
Bruce F
06-06-2008 12:56 AM
Sherlock, Kevin Go to last post
100 773
I am having a very strange issue and looking for some ideas on next troubleshooting steps. Summary: running a delete statement that matches multiple...
06-05-2008 12:45 PM
dev Go to last post
60 464
I tried to add a new database to a working Adaptive Server Anywhere 9 on Windows XP. In Sybase Central, I added the database file path to the end of...
06-04-2008 05:05 PM
Mark A. Parsons Go to last post
10 280
Recently we had performance issue in which cpu was maxed out (100%) for most of the time. I found out user that is using most of the cpu by running...
06-03-2008 08:12 PM
Cory Sane Go to last post
20 260
Hi, While running DBCC CHECKCATALAOG , the following error is seen , how to go about resolving ? any help in this regard is highly appriciated. We...
06-03-2008 05:11 AM
Manish Negandhi Go to last post
10 188
Hi there I want to install Sybase server on the same directory of an old Installation (I had remove the old one) I'd follow the instructions of...
Ramez Nabil
06-02-2008 08:50 AM
Ramez Nabil Go to last post
40 482
Hi In such a cases just manually complete the...
Praveen Gowda
05-28-2008 09:18 AM
Praveen Gowda Go to last post
9 95
How do I access the secondary truncation point status within a stored procedure in ASE 15.0? I have a proc that works in 12.5 but not 15.0. The...
05-23-2008 12:24 PM
ahood Go to last post
80 743
Can I just confirm that, whatever you do with partitioning, the maximum size of a 2k page database in ASE15+ is still 4Tb? I'm pretty sure that's...
05-21-2008 10:46 AM
Sherlock, Kevin Go to last post
20 301
Post New Thread

Display Options
Showing threads 501 to 550 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.