Datacom URT limit to number of tables

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

Is there a limit to the number of database tables defined in a single User Requirement Table(URT)? 

I reviewed the manual and there does not appear to be a limit.

Environment

Release : 15.1

Resolution

There is a limit of 512 tables allowed in the URT's DBURTBL macro statements.

Here is a tip when using a lot of tables: If this is a single URT in a batch job, you can link it 31-bit for better memory usage.

One thing to note here is that even if you are not using every table for a particular process, you will go through the same code and the MUF will open every table in the URT every time it runs. For example, if your process is only looking at 10 tables in a particular execution–but you have 150 tables in your URT–you will open all 150 tables, and this will take a bit of time and memory for the 140 tables you are not using.

Additional Information

For more information about using a User Requirements Table (URT) with your application, please see the documentation section "Defining a User Requirements Table (URT)."

As always, please contact Broadcom support for Datacom if you have further questions.