Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JCONNECT option check

Hello,

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..

Thank you

Regards

Jose

replied

Hi Jose,

When Database is created with jConnect ON (Default) then database should contain jConnect metadata objects.


As consequence, query below should return results.

Tables/view :

select * from systab where lower(table_name) like '%jdbc%'  ;

procedures:

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:

commit;

alter database upgrade JCONNECT ON ;

commit;

Execute the queries above to check if jConnect medatadata are installed.

Hope this helps.

Regards, Tayeb.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question