Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sybase system tables fragmented. What to do?
> sp_configure "allow updates to system tables",1 But I think this is only DML, not DDL. I need to drop and recreate clustered index. Any other idea?- cougar91
- Post #5
- Forum: Sybase: Adaptive (SQL) Server
-
Sybase system tables fragmented. What to do?
Hi Paul, Unfortunately not using data-only locking so can't do REORG. Thought about dropping and recreating a clustered index but since this is a system table, how do I proceed? I seem to remember there is some type of DB option to set so that you can apply DDL (or is it DML only) to system...- cougar91
- Post #3
- Forum: Sybase: Adaptive (SQL) Server
-
Sybase system tables fragmented. What to do?
Hi we are running ASE 12.5.3 on LINUX and I noticed some blocking on system tables sysobjects and syscolumns from time to time. I ran optdiag and it shows both table with very low clustering ratio. I want to see if I can defragment them but they being system tables I wanted to check here to...- cougar91
- Thread
- Replies: 5
- Forum: Sybase: Adaptive (SQL) Server
-
How to invoke sub-process as another user?
Hi, I want to, from a Korn shell script, invoke another script/process as another UNIX user. Due to security constraints the UNIX SAs have restricted the use of the command "su" so that's out. I tried using rsh -l name but gotten no where w/ it. What other options do I have? If...- cougar91
- Thread
- Replies: 1
- Forum: UNIX Scripting
