JCONNECT option check
In IQ 15.4 , is there anyway to verify if the database was initially created with option JCONNECT set to ON or OFF( within create database command) using any command or log files? We do not have the db creation script or a tool to reverse engineer .
I've checked some SPs and system tables but haven't found anything yet..
Tayeb HADJOU replied
When Database is created with jConnect ON (Default) then database should contain jConnect metadata objects.
As consequence, query below should return results.
select * from systab where lower(table_name) like '%jdbc%' ;
select * from sysprocedure where lower(proc_name) like '%jdbc%' ;
Example of objects in the result.
Tables: jdbc_function_escapes, spt_jdbc_conversion, ..
Procedures: sp_jdbc_tables, sp_jdbc_stored_procedures, ..
If results are empty, then jConnect is OFF for this database.
If you need to enable jConnect, connect to database as DBA and execute:
alter database upgrade JCONNECT ON ;
Execute the queries above to check if jConnect medatadata are installed.
Hope this helps.