IBM DB2 private schemas not showing

Database Support
, , , ,
#1

Hi Team,
We are using IBM Db2 database and we want to create report from tables which are present under PRIVATE schemas and not under public schemas. But on Metadata page of Helical Insight application, we are not able to see any private schemas getting listed. How to solve this ?

Thanks,
Netta.

#2

Hi,
BY default Helical Insight only shows public schemas. In order to start seeing all your schemas including PRIVATE and PUBLIC as well as any new schemas which you are going to add in future. Please modify below file :
1.Open file db2.efwd from location “….\hi\hi-repository\System\Admin\DbConfig”
2.You will see something as :

<DataMap id="2" connection="1" type="metadata.dbmetadata">
            <Name>getSchema</Name>
			 <schema>TABLE_SCHEM</schema>
            <Query>
               
                <![CDATA[
				
				 {"catalog":${catalogs},"schema":${schemas},"table":["TABLE","VIEW"],"tablePattern":""}
						
						
                ]]>
           
            </Query>
			<Parameters>
            <Parameter name="catalogs" type="String" default="''"/>
			 <Parameter name="schemas" type="String" default="''"/>
        </Parameters>
        </DataMap>
  1. Change type=“metadata.dbmetadata” to type=“metadata.sql” and
    Within <![CDATA[ ]]>

Write sql to fetch all schemas. For example :
select schema_name as schemas from information_schema.schemata

  1. Save this file and clear all HI application as well as browser cache and again try creating a new metadata, you will start seeing all schemas in the list.

Thank You,
Helical Insight.