ASA Unix版本常见问题解答

Many individuals and organizations use Adaptive Server Anywhere 7 (and its predecessors SQL Anywhere 5, Adaptive Server Anywhere 6) in the various MS Windows environments, and, because of this, there is considerable Adaptive Server Anywhere/SQL Anywhere documentation and commentary, in a Windows context.

However, Adaptive Server Anywhere is a multi platform product running on MS Windows, Novell NetWare, and UNIX. Consequently, some of our newsletter focus needs to reflect this fact.

With this in mind, this month's newsletter will shed some light on Adaptive Server Anywhere/SQL Anywhere, running on the UNIX platform. Specifically, we present the most up-to-date list of Frequently Asked Questions.

Introduction

Getting Started

Q1. Which versions of Unix are supported by SA/ASA?
Q2. Which O/S patches are required by SA/ASA?
Q3. How do I set up my environment to run ASA?

Installing SA/ASA

Q4. How much disk space is required?
Q5. How do I uninstall SA/ASA?
Q6. What are the minimum files required to run SA/ASA?
Q7. How do I get an upgrade or bug fix?
Q8. Where is the on-line help?

Using the Database Engine

Q9. What are the system resources needed by ASA?
Q10. Which engine switches are supported only on Unix?
Q11. Which engine switches are not supported on Unix?
Q12. Which ASA features are not supported on Unix?
Q13. Which ASA features are only supported on some Unix versions?
Q14. How should I shut down the server?
Q15. How do I port my database from Windows to Unix?
Q16. How do I connect to my server through the firewall?
Q17. Which ODBC driver manager should I use on Unix?
Q18. How do I use ASA with one or more of: Apache, PHP, perl, DBD and UnixODBC?

Common Problems and Error Messages

Q19. When trying to install ASA on Linux, I get "dbinstall: error in loading shared libraries: libstdc++.so: cannot open shared object file: No such file or directory
Q20. When trying to start a server, I get: Error in command near "x" followed by the usage screen.
Q21. The ALT key does not work in dbisql (or dbisqlc).
Q22. The function keys F1 to F10 do not work in dbisql (or dbisqlc).
Q23. On RedHat 7.0 or Mandrake Linux, dbisqlc fails to start, with the message "Unable to initialize screen routines:".
Q24. I can create a database with a very long name, but I cannot start an engine on it
Q25. How do I reduce the amount of data ASA places into my messages file?
Q26. ASA6 server on Linux with Win clients hanging during queries
Q27. Can I use SQL Remote under Unix?
Q28. Using PHP, and connecting to ASA via the Sybase ct-libraries. It appears that we can only connect to the first of several databases started on that server.
Q29. Have just installed ASA6 for Linux on pretty basic RedHat 6 setup and cannot start a database engine. I have added all the environment settings, such as path and shared library path. When trying to start dbeng6 or dbsrv6 the following error occurs: BUG IN DYNAMIC LINKER ld.so: dl-version.c: 210: _dl_check_map_versions: Assertion `needed != ((void *)0)' fail!
Q30. Server crash on Linux with Segmentation fault
Q31. How can I make ASA start automatically when the computer starts?
Q32. Can I run ASA 6 on FreeBSD?
Q33. When I start dbsrv6 on Linux it allocates 26 processes. Why?
Q34. Are the Open Client libraries for Linux available separately or do I need to download the entire ASE software?
Q35. Where can I get the DBD::ASAny (Perl) driver?
Q36. I need to change the FTP host for dbremote. Where are the parameters stored on the Linux version? I was prompted for the host name, username, etc. the first time I replicated with the old hostname. It apparently saved these parameter values.
Q37. Which newsgroups are available?
Q38. Can I use "wine" with Sybase software?

Introduction

This document contains frequently asked questions (FAQs), and answers about running Adaptive Server Anywhere on Unix, including limitations of the operating systems and troubleshooting. Some familiarity with both Unix and Adaptive Server Anywhere is assumed.

In this document, SA refers to SQL Anywhere version 5.x, ASA refers to Adaptive Server Anywhere version 6.0 and later, and ASE refers to Adaptive Server Enterprise. Note that issues involving the use of ASE are beyond the scope of this document.

Getting Started

Q1. Which versions of Unix are supported by SA/ASA?
A1. A table of supported platforms is available on my.sybase.com: http://my.sybase.com/detail?id=1002288.

Q2. Which O/S patches are required by SA/ASA?
A2. The following table indicates the suggested and required patches for each version of Unix:

Solaris 7 For JRE 1.2.2 patches, visit java.sun.com/products/jdk/1.2/install-solaris-patches.html">java.sun.com.
Patches 106541-14 and 106980-13 are also suggested to resolve some SIGIO problems that have appeared when using ASA. Solaris 2.6, 7, 8 An as-yet-unnamed patch, which is under development by Sun, is also strongly recommended to resolve another SIGIO issue that has been seen when using ASA. This patch will fix a problem that causes TCP/IP connections to be very slow - so slow that you may think that the connection has hung. This FAQ will be updated as soon as we know the patch number. Linux/RedHat 7.0 Patches for glibc and gcc, visit RedHat.com. IBM AIX 4.3.1 Patch IX81739 (to prevent possible hang of the network server)

Q3. How do I set up my environment to run ASA?
A3. In ASA 7.0.x, two shell script files are provided to set up your environment for you. If you are using the Bourne shell or one of its derivates (sh, ksh, bash), issue the command ". asa_config.sh" to setup your environment. If you are using the C-shell or one of its derivates (csh, tcsh), then issue the command "source asa_config.csh". For ASA and SA versions earlier than 7.0.0, you must use the "export" command to set each variable individually. For example,

PATH=/opt/sybase/SYBSasa6/bin:$PATH
export PATH

The following variables must be set:

PATH  add the location of the 'bin' directory of ASA LD_LIBRARY_PATH (Sun, Linux) add the location of the 'lib' directory of ASA SHLIB_PATH (HP-UX) add the location of the 'lib' directory of ASA LIBPATH (AIX) add the location of the 'lib' directory of ASA

Optionally, the following variables may be set also:

SATMP (or ASTMP) the location for the server's temp files SYBASE the location of the Open Client install (needed by SQLRemote for ASE) ODBCINI full path and name of file to be used in place
of .odbc.ini (default: ~/.odbc.ini) ODBCHOME directory where .odbc.ini is located (not used if ODBCINI is set)

These variables can be set in each user's startup shell script, for example, .bashrc, if desired.

Installing SA/ASA

Q4. How much disk space is required?
A4. It depends on how many options are selected. The table below shows the disk space requirements for the two extremes: a full, network server install with all the options, and a small client install:

Example: ASA 7.0.1
  Full Network Server (MB) Network Client (MB) Solaris 114 58 Linux 107 60 HP-UX 121 69 AIX 81 32

Q5. How do I uninstall SA/ASA?
A5. Delete all the files in the directory specified during the install process. For example, if you have installed ASA into /opt/sybase/SYBSsa7, then enter the command "rm -rf /opt/sybase/SYBSsa7".

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18