Select Schemas to Display - IBM i Access Client Solutions (ACS)

Troubleshooting

Problem

How does the list of libraries (schemas) in ACS via Database -> Schemas get created/populated/maintained?

Resolving The Problem

The list of schemas selected to be displayed in ACS is based off the contents of QUSRSYS/QAUGDBLL for that IBM i *USRPRF.

When a new user expands Schemas within the Database in ACS, the list is initially populated with the QUSRLIBL (User part of the library list) :

This list can be changed by each IBM i *USRPRF by right click on "Schemas" and selecting "Include...".

Changes (Add or Remove) are made from Select Schemas to Display dialog box.

If all libraries are removed, a single record with the value *NONE for that user is all that remains.

If QUSRSYS/QAUGDBLL is deleted, it will be recreated automatically the first time Schemas within Database is expanded by any user.

While not supported, a System Administrator can manipulate QUSRSYS/QAUGDBLL using SQL.

To see what schemas are currently assigned, you can use SQL for a specific User:

SELECT *
FROM QUSRSYS.QAUGDBLL
WHERE "User" = '<UserProfile>';

To clean up QUSRSYS/QAUGDBLL by removing IBM i *USRPRFs that have been removed from the system:

DELETE

  FROM QUSRSYS.QAUGDBLL

 WHERE "User" not in (SELECT Authorization_name FROM QSYS2.USER_INFO);

To add a set of libraries to an IBM i *USRPRF:

INSERT into QUSRSYS.QAUGDBLL

VALUES ('JANEDOE', 'PAYROLL'),

       ('JANEDOE', 'ACCT_LIB'),

       ('JANEDOE', 'HR_LIB')

This will add libraries PAYROLL, ACCT_LIB, and HR_LIB to the list of schemas when JANEDOE clicks on "Schemas"

Note: "short" name only for libraries.

For iASP's, the QAUGDBLL file with the iASP schema's is stored in the QRCYxxxxx library where xxxxx is the ASP number.

[{"Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001goLAAQ","label":"IBM i Db2-\u003EACS \/ Navigator \/ Run SQL Scripts \/ ODBC"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Version(s)"}]

Historical Number

N1012266

Was this topic helpful?

Document Information

Modified date:
17 March 2025

UID

nas8N1012266

Tips