Error -ODBC license file (IVVM.LIC or DDVM.LIC) not found
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Error -ODBC license file (IVVM.LIC or DDVM.LIC) not found
Hi,
Datastage server is in UNIX machine. Oracle Database is also in unix machine but different one. I configured .odbc.ini, uvodbc.config and dsenv files. I am trying to import ODBC table definition in datastage manager. After providing all inputs - DSN, user name & password when clicking OK button I am getting following error :
"Error - ODBC license file (IVVM.LIC or DDVM.LIC) not found in branded_odbc Directory".
Please sugget what is wrong or is there any other file I have to configure?
Thanks,
Parameswar
Datastage server is in UNIX machine. Oracle Database is also in unix machine but different one. I configured .odbc.ini, uvodbc.config and dsenv files. I am trying to import ODBC table definition in datastage manager. After providing all inputs - DSN, user name & password when clicking OK button I am getting following error :
"Error - ODBC license file (IVVM.LIC or DDVM.LIC) not found in branded_odbc Directory".
Please sugget what is wrong or is there any other file I have to configure?
Thanks,
Parameswar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
First task is to check the branded_odbc directory on the server to determine whether the license files are actually there. The branded_odbc directory is usually a sibling of the DataStage engine directories (DSEngine and PXEngine).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Hi Ray,ray.wurlod wrote:First task is to check the branded_odbc directory on the server to determine whether the license files are actually there. The branded_odbc directory is usually a sibling of the DataStage engine dire ...
IVVM.LIC file is there in branded_odbc Directory. But this directory is in ../DataStage, nither in ../PXEngine nor ...DSEngine directory.
Thanks,
Parameswar
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Yes it is there in SHLIB_PATH as .../home/dsadm/Ascential/DataStage/branded_odbc/lib..ray.wurlod wrote:Does LD_LIBRARY_PATH include branded_odbc/lib ? ...
Onething I have noticed from odbcref.pdf manual that $APT_ORCHHOME/branded_odbc /lib to be include SHLIB_PATH. But in dsenv APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine add branded_odbc folder is not there in PXEngine directory.
Is there anything I am missing ?
Thanks,
Parameswar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Now I'm confused. All of the following must be in SHLIB_PATH, and before any database libraries:
$DSHOME/lib
$APT_ORCHHOME/lib
branded_odbc/lib
As far as I can determine, there is no branded_odbc within the $APT_ORCHHOME directory.
$DSHOME/lib
$APT_ORCHHOME/lib
branded_odbc/lib
As far as I can determine, there is no branded_odbc within the $APT_ORCHHOME directory.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Hi Ray,ray.wurlod wrote:Now I'm confused. All of the following must be in SHLIB_PATH, and before any database libraries:
$DSHOME/lib
$APT_ORCHHOME/lib
branded_odbc/lib
As far as I can determine, there is no branded_od ...
Thanks for your response. Since I am not a premium member, I am unable to read your full answer.
Shall I copy branded_odbc directory from .../DataStage/ into .../PXEngine/ so that I can set the $APT_ORCHHOME/lib branded_odbc/lib path in dsenv file which is as per manual.
Thanks,
Parameswar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No. That's not required. (That is, I don't have that in place, and it's working fine for me.)
Premium membership is only a few cents per day, is definitely worth it, and helps to pay for the bandwidth costs of DSXchange.
Premium membership is only a few cents per day, is definitely worth it, and helps to pay for the bandwidth costs of DSXchange.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Parameswar,
We got similar message while ODBC configurations. Go to .odbc.ini file and change the path from #Branded_ODBC_DIR# to corresponding ODBC install dir.
[ODBC]
IANAAppCodePage=4
InstallDir=#Branded_ODBC_DIR#
Trace=1
TraceDll=#Branded_ODBC_DIR#/lib/odbctrac.so
TraceFile=#Branded_ODBC_DIR#/odbctrace.out
UseCursorLib=0
This should fix the issue.
We got similar message while ODBC configurations. Go to .odbc.ini file and change the path from #Branded_ODBC_DIR# to corresponding ODBC install dir.
[ODBC]
IANAAppCodePage=4
InstallDir=#Branded_ODBC_DIR#
Trace=1
TraceDll=#Branded_ODBC_DIR#/lib/odbctrac.so
TraceFile=#Branded_ODBC_DIR#/odbctrace.out
UseCursorLib=0
This should fix the issue.
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Hi Ranjana,Ranjana wrote:Parameswar,
We got similar message while ODBC configurations. Go to .odbc.ini file and change the path from #Branded_ODBC_DIR# to corresponding ODBC install dir.
[ODBC]
IANAAppCodePage=4
InstallDir=#Branded_ODBC_DIR#
Trace=1
TraceDll=#Branded_ODBC_DIR#/lib/odbctrac.so
TraceFile=#Branded_ODBC_DIR#/odbctrace.out
UseCursorLib=0
This should fix the issue.
Actually we have not installed any ODBC driver. We are using the default data direct ODBC driver that is coming with DataStage. Here is the current path setting in odbc.ini file.
[ODBC]
IANAAppCodePage=4
InstallDir=/home/dsadm/Ascential/DataStage/branded_odbc
Trace=0
TraceDll=/home/dsadm/Ascential/DataStage/branded_odbc/lib/odbctrac.sl
TraceFile=odbctrace.out
UseCursorLib=0
As per your suggestion, I am not getting odbctrace.out within branded_odbc directory . Also instead of odbctrac.so I am getting odbctrac.sl file within lib/ directory.
Is there anything I have to install for these file.
Thanks,
Parameswar
Some systems use .so files, some .sl so no worries there. And the 'trace.out' file will only be created when you have things working and turn trace on. Again, all fine.
Is the 'InstallDir' noted in your post correct?
Can you post the section of your dsenv file that shows how you are setting the PATH and SHLIB_PATH (or the equivalent for your system) environment variables? If unsure, just post the whole dang thing. Wrapped in
Is the 'InstallDir' noted in your post correct?
Can you post the section of your dsenv file that shows how you are setting the PATH and SHLIB_PATH (or the equivalent for your system) environment variables? If unsure, just post the whole dang thing. Wrapped in
Code: Select all
tags![/b]
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
chulett wrote:Some systems use .so files, some .sl so no worries there. And the 'trace.out' file will only be created when you have things working and turn trace on. Again, all fine.
Is the 'InstallDir' noted in your post correct?
Can you post the section of your dsenv file that shows how you are setting the PATH and SHLIB_PATH (or the equivalent for your system) environment variables? If unsure, just post the whole dang thing. Wrapped inCode: Select all
tags![/b][/quote] Hi Chulett, Here is all the config details. **********dsenv*********** DSHOME=`cat /.dshome` export DSHOME ORACLE_HOME=/u00/app/oracle/product/10.2.0; export ORACLE_HOME DSHOME=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine; export APT_ORCHHOME UDTHOME=/home/dsadm/Ascential/DataStage/ud41; export UDTHOME UDTBIN=/home/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN ODBCINI=$DSHOME/.odbc.ini; export ODBCINI ODBCINF=/home/dsadm/Ascential/DataStage/branded_odbc; export ODBCINF HOME=${HOME:-/}; export HOME SHLIB_PATH=$SHLIB_PATH:$DSHOME/lib:$APT_ORCHHOME/lib:$APT_O RCHHOME/osh_wrappers:$ODBCINF:$ODBCINF/lib:$ORACLE_HOME:$OR ACLE_HO ME/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/ctx/lib:$ORACLE_HOME /rdbms/lib32:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC2.0 :$DSHOM E/java/jre/lib/PA_RISC2.0/hotspot:$DSHOME/java/jre/lib/PA_R ISC/hotspot:/usr/lib:/usr/local/lib:/usr/bin:/usr/local/bin :/usr/b in/X11:/usr/contrib/bin/X11:/usr/lib/X11:/usr/contrib/lib/X 11:/opt/aCC/lib:/opt/aCC/bin; export SHLIB_PATH LD_PRELOAD=$DSHOME/java/jre/lib/PA_RISC2.0/hotspot/libjvm.s l; export LD_PRELOAD PATH=$PATH:$DSHOME/bin:$APT_ORCHHOME/bin:$APT_ORCHHOME/osh_ wrappers:$ODBCINF:$ODBCINF/bin:$ORACLE_HOME/bin; export PATH NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG ************ .odbc.ini************************ [ODBC] IANAAppCodePage=4 InstallDir=/home/dsadm/Ascential/DataStage/branded_odbc Trace=1 TraceDll=/home/dsadm/Ascential/DataStage/branded_odbc/lib/o dbctrac.sl TraceFile=/home/dsadm/Ascential/DataStage/branded_odbc/odbc trace.out UseCursorLib=0 [bancs] QEWSD=39247 Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo ra20.sl Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 DescribeAtPrepare=0 EnableDescribeParam=0 EnableNcharSupport=0 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 HostName=UXJEDB04 LocalTimeZoneOffset= LockTimeOut=-1 LogonID=staging Password=staging PortNumber=1521 ProcedureRetResults=0 SID=rpd1 UseCurrentSchema=1 [FRSTEST] Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo ra20.sl Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 DescribeAtPrepare=0 EnableDescribeParam=0 EnableNcharSupport=0 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 HostName=FRSTEST LocalTimeZoneOffset= LockTimeOut=-1 LogonID=019781 Password=password323 PortNumber=1521 ProcedureRetResults=0 SID=FRSTEST UseCurrentSchema=1 [OFDM] Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo ra20.sl Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 DescribeAtPrepare=0 EnableDescribeParam=0 EnableNcharSupport=0 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 HostName=UXJEDB05 LocalTimeZoneOffset= LockTimeOut=-1 LogonID=ofsd Password=ofsd PortNumber=1521 ProcedureRetResults=0 SID=OFDM UseCurrentSchema=1 [CCRDEV] Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo ra20.sl Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 DescribeAtPrepare=0 EnableDescribeParam=0 EnableNcharSupport=0 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 HostName=ERM LocalTimeZoneOffset= LockTimeOut=-1 LogonID=ccr_guest Password=ccr_guest PortNumber=1521 ProcedureRetResults=0 SID=ccrt UseCurrentSchema=1 [DIMDEV] Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo ra20.sl Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 DescribeAtPrepare=0 EnableDescribeParam=0 EnableNcharSupport=0 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 HostName=HPUS33 LocalTimeZoneOffset= LockTimeOut=-1 LogonID=usa Password=usa PortNumber=1521 ProcedureRetResults=0 SID=dimdev UseCurrentSchema=1 [DWDEV] Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo ra20.sl Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 DescribeAtPrepare=0 EnableDescribeParam=0 EnableNcharSupport=0 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 HostName=HPUS33 LocalTimeZoneOffset= LockTimeOut=-1 LogonID=usa Password=usa PortNumber=1521 ProcedureRetResults=0 SID=dwdev UseCurrentSchema=1 [AOL] Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMm sss20.sl Description=DataDirect SQL Server Wire Protocol Database=db LogonID=sa Password=password Address=BSDSQL,1433 QuotedId=No AnsiNPW=No **************uvodbc.congig**************** [ODBC DATA SOURCES] <localuv> DBMSTYPE = UNIVERSE network = TCP/IP service = uvserver host = 127.0.0.1 <DIMDEV> DBMSTYPE = ODBC <IVRDevt> DBMSTYPE = ODBC <CCRDEV> DBMSTYPE = ODBC <eCorpDevt> DBMSTYPE = ODBC <OFDM> DBMSTYPE = ODBC <DWDEV> DBMSTYPE = ODBC <USA> DBMSTYPE = ODBC <DWHDEVT> DBMSTYPE = ODBC <LETSTEST> DBMSTYPE = ODBC <RPD1> DBMSTYPE = ODBC <FRSTEST> DBMSTYPE = ODBC <CCRT> DBMSTYPE = ODBC <BANCS> DBMSTYPE = ODBC <AOL> DBMSTYPE = ODBC I need your help to fix this issue. Actually I am new in this configuration area. Whenever you have time,please go through these.I will be obliged with your help. Thanks, Parameswar