isql: command not found

[Former Member]

Hi Experts,

I just installed SAP EHP7 with SYBASE ASE 15.7.0.122 on Red Hat Enterprise Linux Server release 6.5 (Santiago).

When I am trying to connect to isql with the user: syb<sid> and with the command:

isql -Usapsa -S<SID> -X but it it giving the error output as: isql: command not found

I also tried the command from the path: /sybase/<SID>/OCS-15_0/bin but giving the same error but it is getting connected with the command:

isql64 -Usapsa -S<SID> -X

I have checked the permission and owner of the files that are properly set and I though that this is the problem with the environment variables but I believe all are properly set. FYR.. the below are the environment variable:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

PATH=/sybase/DEV/ASE-15_0/jobscheduler/bin:/sybase/DEV/ASE-15_0/bin:/sybase/DEV/ ASE-15_0/install:/sybase/DEV/OCS-15_0/bin:/usr/lib64/qt-                   3.3/bin:/usr/local/bin:/bin:/usr/bin

SAP_JRE7_32=/sybase/DEV/shared/SAPJRE-7_1_011_32BIT

SAP_JRE7=/sybase/DEV/shared/SAPJRE-7_1_011_64BIT

SAP_JRE7_64=/sybase/DEV/shared/SAPJRE-7_1_011_64BIT

SYBASE_OCS=OCS-15_0

INCLUDE=/sybase/DEV/OCS-15_0/include:

LIB=/sybase/DEV/OCS-15_0/lib:

LD_LIBRARY_PATH=/sybase/DEV/ASE-15_0/lib:/sybase/DEV/OCS-15_0/lib:/sybase/DEV/OCS-15_0/lib3p64:/sybase/DEV/OCS-15_0/lib3p:

SYBASE=/sybase/DEV

SYBASE_ASE=ASE-15_0

SYBROOT=/sybase/DEV

SYBASE_JRE_RTDS=/sybase/DEV/shared/SAPJRE-7_1_011_64BIT

SYBASE_WS=WS-15_0

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Now my questions are:

1) What could be the reason for this behavior?

2) What is the difference b/w isql and isql64?

3) backup taken by isql64 will be restored with isql?

Thanks and Regards
KLNR

[former_member3043]

Hello,

isql is 32-bit and isql is 64-bit, both are doing and working the same way.

I'm wondering that the SP122 just contains the isql64, you should have both, could you post here:

cd $SYBASE\OCS-15_0\bin

ls -la isql*

You should see isql, isql64, isql_r and isql_r64

Mean you can restore the backup either with isql64 or isql, doesn't matter what isql you used before.

Regards

Stefan

[Former Member]

Thanks Stefan for your reply,

I got the same answer in the below link:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc30191.1570100/doc/html/sa...

in $SYBASE\OCS-15_0\bin I could see:

-rwxr-x---. 1 sybdev sapsys 1662380 Apr 14 08:48 isql

-rwxr-x---. 1 sybdev sapsys 1810334 Apr 14 09:15 isql64

-rwxr-x---. 1 sybdev sapsys 1686751 Apr 14 09:39 isql_r

-rwxr-x---. 1 sybdev sapsys 1835709 Apr 14 10:04 isql_r64

Finally I have renamed the isql and created a logical link from isql64 to isql

Thanks and Regards
KLNR

[ryan_hansen]

Hi K LNR,

There was an issue a while back with the environment variables.
Here is yours:
LD_LIBRARY_PATH=/sybase/DEV/ASE-15_0/lib:/sybase/DEV/OCS-15_0/lib:/sybase/DEV/OCS-15_0/lib3p64:/sybase/DEV/OCS-15_0/lib3p:

You notice how 64bit libraries are picked up before 32bit libraries?
lib3p64 then lib3p.

If you switch these I wonder if isql will work and isql64 will start failling.

Regards,

Ryan