Is there an Informix function, either built-in or easily implemented, that will create a new UUID value?  Ideally, something that could be used in an INSERT statement, for instance.  Something like:

INSERT INTO table_xyz
  ( uuid, name, rank, serial_nbr)
VALUES (make_uuid(), "John Doe", "PFC", 11552328);

This would be for IDS 14.10.FC11.

------------------------------
mark collins
------------------------------

Is there an Informix function, either built-in or easily implemented, that will create a new UUID value?  Ideally, something that could be used in an INSERT statement, for instance.  Something like:

INSERT INTO table_xyz
  ( uuid, name, rank, serial_nbr)
VALUES (make_uuid(), "John Doe", "PFC", 11552328);

This would be for IDS 14.10.FC11.

------------------------------
mark collins
------------------------------

Is there an Informix function, either built-in or easily implemented, that will create a new UUID value?  Ideally, something that could be used in an INSERT statement, for instance.  Something like:

INSERT INTO table_xyz
  ( uuid, name, rank, serial_nbr)
VALUES (make_uuid(), "John Doe", "PFC", 11552328);

This would be for IDS 14.10.FC11.

------------------------------
mark collins
------------------------------

Thanks Paul.

I found the page I think you were referring to, and I ran the 'CREATE FUNCTION UUID() RETURNING CHAR(36) EXTERNAL NAME 'com.informix.judrs.IfxStrings.getUUID()' language java;' statement and granted permission to public.

When I run 'SELECT UUID() FROM sysmaster:sysdual', I get the error message 'SQL Error (-9431): Can't find system class or method or library (/informix/current/extend/krakatoa/jre/bin/j9vm/libjvm.so).'

I looked under /informix/current/extend/krakatoa and found that jre was a symlink pointing to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.432.b06-2.el8.x86_64/jre, which does not exist on this server.  Running 'which java' returns /usr/lib/jvm/jre-17/bin/java.  I looked in /usr/lib/jvm/jre-17/bin, but there is no j9vm subdirectory.  I also tried a 'find /usr/lib/jvm/jre-17/bin -name libjvm.so', but got no results.  I eventually found it under /usr/lib/jvm/jre-17/lib/server/libjvm.so. 

I can change the symlink /informix/current/extend/krakatoa/jre to point to /usr/lib/jvm/jre-17, which would at least get it in the correct vicinity.  But since the error is saying that it's trying to find libjvm.so in /informix/current/extend/krakatoa/jre/bin/j9vm/libjvm.so, that won't solve the problem.  My libjvm.so is in /informix/current/extend/krakatoa/jre/lib/server.

Is there an environment variable or config parameter that can be set to change where the server is expecting this library?

Thanks.

Is there an Informix function, either built-in or easily implemented, that will create a new UUID value?  Ideally, something that could be used in an INSERT statement, for instance.  Something like:

INSERT INTO table_xyz
  ( uuid, name, rank, serial_nbr)
VALUES (make_uuid(), "John Doe", "PFC", 11552328);

This would be for IDS 14.10.FC11.

------------------------------
mark collins
------------------------------

Thanks Paul.

I found the page I think you were referring to, and I ran the 'CREATE FUNCTION UUID() RETURNING CHAR(36) EXTERNAL NAME 'com.informix.judrs.IfxStrings.getUUID()' language java;' statement and granted permission to public.

When I run 'SELECT UUID() FROM sysmaster:sysdual', I get the error message 'SQL Error (-9431): Can't find system class or method or library (/informix/current/extend/krakatoa/jre/bin/j9vm/libjvm.so).'

I looked under /informix/current/extend/krakatoa and found that jre was a symlink pointing to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.432.b06-2.el8.x86_64/jre, which does not exist on this server.  Running 'which java' returns /usr/lib/jvm/jre-17/bin/java.  I looked in /usr/lib/jvm/jre-17/bin, but there is no j9vm subdirectory.  I also tried a 'find /usr/lib/jvm/jre-17/bin -name libjvm.so', but got no results.  I eventually found it under /usr/lib/jvm/jre-17/lib/server/libjvm.so. 

I can change the symlink /informix/current/extend/krakatoa/jre to point to /usr/lib/jvm/jre-17, which would at least get it in the correct vicinity.  But since the error is saying that it's trying to find libjvm.so in /informix/current/extend/krakatoa/jre/bin/j9vm/libjvm.so, that won't solve the problem.  My libjvm.so is in /informix/current/extend/krakatoa/jre/lib/server.

Is there an environment variable or config parameter that can be set to change where the server is expecting this library?

Thanks.

Is there an Informix function, either built-in or easily implemented, that will create a new UUID value?  Ideally, something that could be used in an INSERT statement, for instance.  Something like:

INSERT INTO table_xyz
  ( uuid, name, rank, serial_nbr)
VALUES (make_uuid(), "John Doe", "PFC", 11552328);

This would be for IDS 14.10.FC11.

------------------------------
mark collins
------------------------------

Thanks Paul.

I found the page I think you were referring to, and I ran the 'CREATE FUNCTION UUID() RETURNING CHAR(36) EXTERNAL NAME 'com.informix.judrs.IfxStrings.getUUID()' language java;' statement and granted permission to public.

When I run 'SELECT UUID() FROM sysmaster:sysdual', I get the error message 'SQL Error (-9431): Can't find system class or method or library (/informix/current/extend/krakatoa/jre/bin/j9vm/libjvm.so).'

I looked under /informix/current/extend/krakatoa and found that jre was a symlink pointing to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.432.b06-2.el8.x86_64/jre, which does not exist on this server.  Running 'which java' returns /usr/lib/jvm/jre-17/bin/java.  I looked in /usr/lib/jvm/jre-17/bin, but there is no j9vm subdirectory.  I also tried a 'find /usr/lib/jvm/jre-17/bin -name libjvm.so', but got no results.  I eventually found it under /usr/lib/jvm/jre-17/lib/server/libjvm.so. 

I can change the symlink /informix/current/extend/krakatoa/jre to point to /usr/lib/jvm/jre-17, which would at least get it in the correct vicinity.  But since the error is saying that it's trying to find libjvm.so in /informix/current/extend/krakatoa/jre/bin/j9vm/libjvm.so, that won't solve the problem.  My libjvm.so is in /informix/current/extend/krakatoa/jre/lib/server.

Is there an environment variable or config parameter that can be set to change where the server is expecting this library?

Thanks.

Is there an Informix function, either built-in or easily implemented, that will create a new UUID value?  Ideally, something that could be used in an INSERT statement, for instance.  Something like:

INSERT INTO table_xyz
  ( uuid, name, rank, serial_nbr)
VALUES (make_uuid(), "John Doe", "PFC", 11552328);

This would be for IDS 14.10.FC11.

------------------------------
mark collins
------------------------------

Looking in onconfig.std, I see:

Since I've changed the symlink $INFORMIXDIR/extend/krakatoa/jre to point to our current JRE, I think I need to also set JVPJAVAVM to 'lib/server' or maybe './lib/server', since it's relative to JVPJAVAHOME.  If I'm reading the onconfig comments correctly, that would point the server to $INFORMIXDIR/extend/krakatoa/jre/lib/server/libjvm.so, which should address the error message I'm currently getting.

I've tried 'onmode -wm JVPJAVAVM="./lib/server"' but I get "Configuration Parameter to be changed is not valid or not supported with this option."  Does this mean that I need to update the onconfig manually and restart the instance?  Or can the Admin API call make this change?

------------------------------
mark collins

Original Message:
Sent: Wed September 17, 2025 04:18 PM
From: mark collins
Subject: UUID

Thanks Paul.

I found the page I think you were referring to, and I ran the 'CREATE FUNCTION UUID() RETURNING CHAR(36) EXTERNAL NAME 'com.informix.judrs.IfxStrings.getUUID()' language java;' statement and granted permission to public.

When I run 'SELECT UUID() FROM sysmaster:sysdual', I get the error message 'SQL Error (-9431): Can't find system class or method or library (/informix/current/extend/krakatoa/jre/bin/j9vm/libjvm.so).'

I looked under /informix/current/extend/krakatoa and found that jre was a symlink pointing to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.432.b06-2.el8.x86_64/jre, which does not exist on this server.  Running 'which java' returns /usr/lib/jvm/jre-17/bin/java.  I looked in /usr/lib/jvm/jre-17/bin, but there is no j9vm subdirectory.  I also tried a 'find /usr/lib/jvm/jre-17/bin -name libjvm.so', but got no results.  I eventually found it under /usr/lib/jvm/jre-17/lib/server/libjvm.so. 

I can change the symlink /informix/current/extend/krakatoa/jre to point to /usr/lib/jvm/jre-17, which would at least get it in the correct vicinity.  But since the error is saying that it's trying to find libjvm.so in /informix/current/extend/krakatoa/jre/bin/j9vm/libjvm.so, that won't solve the problem.  My libjvm.so is in /informix/current/extend/krakatoa/jre/lib/server.

Is there an environment variable or config parameter that can be set to change where the server is expecting this library?

Thanks.

------------------------------
mark collins

Original Message:
Sent: Wed September 17, 2025 03:16 PM
From: Paul Watson
Subject: UUID

Original Message:
Sent: 9/17/2025 3:13:00 PM
From: Paul Watson
Subject: RE: UUID

Original Message:
Sent: 9/17/2025 3:04:00 PM
From: mark collins
Subject: UUID

Is there an Informix function, either built-in or easily implemented, that will create a new UUID value?  Ideally, something that could be used in an INSERT statement, for instance.  Something like:

INSERT INTO table_xyz
  ( uuid, name, rank, serial_nbr)
VALUES (make_uuid(), "John Doe", "PFC", 11552328);

This would be for IDS 14.10.FC11.

------------------------------
mark collins
------------------------------