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...
hitgon
07-28-2008 07:25 PM
A. M. Go to last post
30 309
I have executed a select statement, i got the below error message. Server Message: Number 3626, Severity 17 Server 'DEV', Line 1: The transaction...
Karthikeyan.M
07-28-2008 11:01 AM
Sherlock, Kevin Go to last post
60 657
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 997
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...
fiaola
07-25-2008 10:01 PM
Sherlock, Kevin Go to last post
110 703
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 395
Where can I locate any documentation on moving a databases segments to new devices? Im on ASE 15.0.2.
usao
07-25-2008 04:00 PM
Bret Halford Go to last post
10 165
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...
techgrl
07-25-2008 01:30 AM
ThanksButNo Go to last post
60 553
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...
HM
07-24-2008 05:53 PM
Mark A. Parsons Go to last post
60 774
how to reset values displayed by monitorconfig without rebooting the ASE server?
newbiew
07-22-2008 09:53 PM
Manish Negandhi Go to last post
10 223
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 300
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...
techgrl
07-18-2008 03:20 PM
Sherlock, Kevin Go to last post
10 321
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: 3.42.1.1: LOAD is complete...
Mike G
07-18-2008 01:30 PM
Mike G Go to last post
20 220
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 387
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...
ThanksButNo
07-15-2008 08:21 PM
ThanksButNo Go to last post
20 469
Can anyone tell me the adavntage or disadvantages of using user roles over database groups for user permissioning
David
07-15-2008 11:51 AM
bslade Go to last post
60 773
Hi guys, Is there any way to correctly estimate time for the creation of clustered index by primary key constraint. thanks
HM
07-14-2008 08:17 AM
Manish Negandhi Go to last post
10 159
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: -...
idOT
07-10-2008 03:32 PM
Bret Halford Go to last post
9 73
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...
upmirji
07-09-2008 09:40 PM
ThanksButNo Go to last post
20 273
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...
David
07-08-2008 10:50 AM
Bret Halford Go to last post
10 287
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...
HM
07-07-2008 12:12 PM
Bret Halford Go to last post
10 314
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 250
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...
dev
07-02-2008 06:31 PM
dev Go to last post
30 423
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...
monmon
06-29-2008 02:21 PM
Mark A. Parsons Go to last post
30 328
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 164
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...
chad.m.adams@us.army.mil
06-26-2008 01:21 PM
peter collard Go to last post
10 142
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 913
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...
silent_asasinn@yahoo.co.in
06-25-2008 05:12 PM
peter collard Go to last post
40 321
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 597
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 186
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...
ThanksButNo
06-19-2008 11:10 PM
ThanksButNo Go to last post
30 575
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 549
Is it better to run the dbcc before a reorg on a database (table)or visa versa?and why?
David
06-18-2008 12:39 PM
Bret Halford Go to last post
20 414
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 150
Hi everybody, I've encountered a weird problem, hoping that someone could help me out. I have a table with schema like...
Alex
06-16-2008 10:52 AM
Bret Halford Go to last post
30 237
Hi there, Anyone know how to repopulate master..sysroles if is accidentally deleted ? There is a bcp file containing all the info required to...
mully
06-13-2008 10:44 AM
Sherlock, Kevin Go to last post
10 240
is there any benifit of using 4k page size over 2k on solaris for ase 15.0.2?
dev
06-13-2008 03:38 AM
peter collard Go to last post
100 699
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 553
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...
Motif
06-11-2008 09:20 AM
Motif Go to last post
20 326
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 659
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...
Raj
06-10-2008 11:06 AM
Sherlock, Kevin Go to last post
40 501
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 ------...
developer
06-09-2008 11:56 PM
Manish Negandhi Go to last post
10 186
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 609
I am having a very strange issue and looking for some ideas on next troubleshooting steps. Summary: running a delete statement that matches multiple...
alacrite@gmail.com
06-05-2008 12:45 PM
dev Go to last post
60 347
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...
jkj
06-04-2008 05:05 PM
Mark A. Parsons Go to last post
10 222
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...
Amit
06-03-2008 08:12 PM
Cory Sane Go to last post
20 195
Hi, While running DBCC CHECKCATALAOG , the following error is seen , how to go about resolving ? any help in this regard is highly appriciated. We...
upmirji
06-03-2008 05:11 AM
Manish Negandhi Go to last post
10 154
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 373
Hi In such a cases just manually complete the...
Praveen Gowda
05-28-2008 09:18 AM
Praveen Gowda Go to last post
9 69
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...
ahood
05-23-2008 12:24 PM
ahood Go to last post
80 541
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...
jd
05-21-2008 10:46 AM
Sherlock, Kevin Go to last post
20 230
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 - 2014, Jelsoft Enterprises Ltd.