Record xxxx in DS_ROUTINES is locked by another user

Umbix62 · Post by **Umbix62** » Wed Sep 02, 2015 8:20 am

Hi

I'm trying to compile a Parallel Job calling an external Routine. This routine is writen in c and I compile it using xlc_r compiler (option -c -q64 -O). It works fine but when I try to compile the Job Datastage return this message:

"Record <routine name> in DS_ROUTINES is locked by another user". Anyway the job is compiled but during the Runtime it aborts with this message:

EXPTRANS: Failed to load the library "V0S1_PX_AN01_M_EXPTRANS.o"; either the directory containing the library file
is not on the library search path, or the library was compiled on a system
that is incompatible with this system: Could not load "V0S1_PX_AN01_M_EXPTRANS": rtld: 0712-001 Symbol Decode__FPcN31 was referenced
from module /opt/IBM/InformationServer/Server/Projects/PR_TGK_QUAL/RT_BP261.O/V0S1_PX_AN01_M_EXPTRANS.o(), but a runtime definition
of the symbol was not found.
rtld: 0712-002 fatal error: exiting..

EXPTRANS is the transformer's name calling the extrenal function.

My question is....how can unlock the record in DS_ROUTINES to compile my parallel Job without error?

Thnak you very much in advance....

Umberto

ray.wurlod · Post by **ray.wurlod** » Wed Sep 02, 2015 4:45 pm

Search DSXchange for information about the UNLOCK command.

Umbix62 · Post by **Umbix62** » Thu Sep 03, 2015 5:17 am

Thank you very much Ruy. I have now another question. The external routines is corretly compiled. I have compiled also the Job parallel and set, before running it, the environment variable LD_PATH_LIB with the library's path containing the .o file generated. The Job abort and the message reported is like this:

"Transformer_3: Failed to load the library "V0S3_Untitled11_Transformer_3.o"; either the directory containing the library file
is not on the library search path, or the library was compiled on a system
that is incompatible with this system: Could not load "V0S3_Untitled11_Transformer_3": rtld: 0712-001 Symbol Decode__FPcN31 was referenced
from module /opt/IBM/InformationServer/Server/Projects/PR_TGK_QUAL/RT_BP263.O/V0S3_Untitled11_Transformer_3.o(), but a runtime definition
of the symbol was not found.
rtld: 0712-002 fatal error: exiting.."

Can you help me to resolve this problem?

ArndW · Post by **ArndW** » Thu Sep 03, 2015 7:27 am

This is a different issue that doesn't match the subject anymore. Please use the search functionality, for example for the string "library search path, or the library" and you'll see that several threads discuss this type of issue with custom routines and also how the problem was solved. The search functionality is really quite useful, if somewhat underused.

Umbix62 · Post by **Umbix62** » Thu Sep 03, 2015 7:49 am

Thank you very much. I'll try to search.....

chulett · Post by **chulett** » Thu Sep 03, 2015 7:53 am

Make sure you use the exact search option with an appropriate string, the others are a little... limited.