search cancel

Newly added Db2 Profiles not showing up in IDB2 under D Profiles command

book

Article ID: 252973

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

New Db2 connection profiles were added to the DSN_PROFILE_TABLE and enabled, but those new profiles are not showing up under D Profiles in IDB2. Why these profiles aren't showing up on that panel? The first screenshot is of the IDB2 R/PROFILES screen where the profiles are missing. The second screenshot is of RC/Query where the profiles are listed under RC/Query., and will also send in a query of the profile table itself to show that the profiles do exist. The Profile IDs in question are 505 and 506

 

Environment

Release : 20.0

Resolution

After adding the new Db2 connection profiles to the DSN_PROFILE_TABLE and enabling them, user needed to load the table for the profile to become available in R/PROFILES screen.