User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
IBM DB2 on AS400

Looker supports IBM’s DB2 database on AS400, which is discussed here.

Looker also supports IBM’s DB2 for Linux, Unix, and Windows (LUW), as described on this documentation page, and connecting to a DB2 Warehouse on Cloud (dashDB), as described on this documentation page.

To connect Looker to your IBM DB2 database on AS400, follow the steps below:

Add the AS400 Driver

  1. In the looker directory, create a text file named custom_jdbc_config.yml that contains the following:

    - name: as400
      dir_name: as400
      module_path: com.ibm.as400.access.AS400JDBCDriver
    
  2. In the looker directory, create a new directory called custom_jbdc_drivers, and then under that new directory, create a new directory called as400.

  3. Copy the file jt400.jar to the new as400 directory. You can download the jt400.jar file here. jt400.jar is in the jtopen_9_6.zip file.

  4. Create or update the file lookerstart.cfg and add the following:

    LOOKERARGS="${LOOKERARGS} --use-custom-jdbc-config"
    
  5. If Looker is running, restart Looker.

Users and Security

Create a user with a secure password to connect to Looker. This user should have read access to all tables to be explored in Looker.

PDTs

Use the following command to create a schema:

CREATE SCHEMA looker_scratch

Give the user that will access Looker write access to the schema.

Query Killing

In order to enable query killing, implement the following stored procedure:

CREATE OR REPLACE PROCEDURE LOOKER_CANCEL_ACTIVITY (IN application_handle INTEGER) LANGUAGE SQL BEGIN DECLARE UOW_ID INTEGER; DECLARE ACTIVITY_ID INTEGER; FOR v AS cur1 CURSOR FOR SELECT UOW_ID, ACTIVITY_ID FROM TABLE(SYSPROC.MON_GET_ACTIVITY(application_handle, -1)) DO CALL WLM_CANCEL_ACTIVITY(application_handle, v.uow_id, v.activity_id); END FOR ; END

Feature Support

Looker’s ability to provide some features depends on whether the database dialect can support them.

In the current Looker release, IBM DB2 supports the following Looker features:

Next Steps

After completing the database configuration, you can connect to the database from Looker using these directions.

Top