Error -ODBC license file (IVVM.LIC or DDVM.LIC) not found

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
parameswar
Premium Member
Premium Member
Posts: 66
Joined: Sun Apr 08, 2007 12:34 pm

Error -ODBC license file (IVVM.LIC or DDVM.LIC) not found

Post by parameswar »

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
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

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.
Top
parameswar
Premium Member
Premium Member
Posts: 66
Joined: Sun Apr 08, 2007 12:34 pm

Post by parameswar »

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 ...
Hi Ray,
IVVM.LIC file is there in branded_odbc Directory. But this directory is in ../DataStage, nither in ../PXEngine nor ...DSEngine directory.

Thanks,
Parameswar
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Which is fine and right where it belongs. Are the permissions correct such that your user can read them?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
parameswar
Premium Member
Premium Member
Posts: 66
Joined: Sun Apr 08, 2007 12:34 pm

Post by parameswar »

chulett wrote:Which is fine and right where it belongs. Are the permissions correct such that your user can read them? ...

Permission is as : -rwxr-xr-x
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Does LD_LIBRARY_PATH include branded_odbc/lib ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
parameswar
Premium Member
Premium Member
Posts: 66
Joined: Sun Apr 08, 2007 12:34 pm

Post by parameswar »

ray.wurlod wrote:Does LD_LIBRARY_PATH include branded_odbc/lib ? ...
Yes it is there in SHLIB_PATH as .../home/dsadm/Ascential/DataStage/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
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
parameswar
Premium Member
Premium Member
Posts: 66
Joined: Sun Apr 08, 2007 12:34 pm

Post by parameswar »

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 ...
Hi Ray,

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
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Ranjana
Premium Member
Premium Member
Posts: 6
Joined: Fri Oct 13, 2006 8:31 am
Location: Chicago

Post by Ranjana »

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.
Top
parameswar
Premium Member
Premium Member
Posts: 66
Joined: Sun Apr 08, 2007 12:34 pm

Post by parameswar »

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.
Hi Ranjana,
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
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

Code: Select all

 tags![/b]
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
parameswar
Premium Member
Premium Member
Posts: 66
Joined: Sun Apr 08, 2007 12:34 pm

Post by parameswar »

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 in

Code: 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
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”