Solved

Questions on Sybase IQ

Posted on 2012-03-21
3
582 Views
Last Modified: 2012-08-24
Hi

Three questions on Sybase IQ :

1. Is there anyway to recover lost DBA password?
2. Does Sybase IQ support OS authentication?
3. As per Sybase , Volume management software is not recommended for Sybase IQ devices. What is the reason?

Can anyone help ?

thanks
CS
0
Comment
Question by:ncshome170
  • 2
3 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 37764743
1. Opinion is divided. Sybase Tech Support have told some people DBA passwords cannot be recovered for IQ or ASA, and told others that it can.

2. Yes, via Kerberos. You need the separately licensed "Sybase IQ Advanced Security Option" for this. This might not be available in versions below a certain version of IQ.

3. I'm not aware of any issues. Have you been told to avoid them? Raw partitions pretty much beat anything else for performance, but some volume management software is almost as good - and better than standard file systems.
0
 

Author Comment

by:ncshome170
ID: 37774980
Thanks Joe.

We can find the following message in Sybase IQ training material  :

Volume management software is not recommended for Sybase IQ.

- CS
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 37784438
Hm, how odd. I can't find anything to explain that in the Sybase manuals or in any of the IQ presentations at the last few years of Techwave conferences. Ask your instructor?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
This article outlines the process to identify and resolve account lockout in an Active Directory environment.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question