IBM Mainframe Forum

Hi,

Suppose If I want to make some updates in Parent table then I need to update corresponding child tables too.
But, how can I know the child table names associated with parent table in DB2.

Could any one explain me.

Thanks,
Chetan

Hello,

If this has not already been provided via an entity relationship diagram of something similar, you should talk with your dba.

Hello,

when browsing the table using DB2 fileaid, use command 'rbrowse' it will display all parent and child relations for that table.

see below screens for more help:

QAOS#2 D for DB2 Browse RAVFS2.TVFPAYI_PI SSID: DQA0
COMMAND ===> rbrowse SCROLL ===> CSR
PI_ID PARTITION_NO IMPORT_FILE_ID PI_SUB_TYPE_ID SYSTEM_S
DEC(11,0) SMALLINT DEC(11,0) SMALLINT CHAR(4)
------PRIMARY ------------ -------------- -------------- --------
000001 950. 1 ------------- 5 COMP
000002 3400. 1 ------------- 5 COMP

then press enter and following screen will appear;

QAOS#2 Row 1 to 6 of 23
COMMAND ===>

A one to one or one to many relationship exists.
Use ADD to create a new application relationship or select an existing
relationship definition.
To edit a view: overtype displayed table name with a valid single table
view name.

Line Commands:
S - Select table
I - Relationship Information

CMD Creator Table/View Type
--- -------- ------------------- --------------------------------
_ RAVFS2 TVFACCC_CHARGE_ACC RI - CHILD
_ RAVFS2 TVFBENF_BENEFICRY RI - CHILD
_ RAVFS2 TVFBLKT_BLKLST_TMP RI - CHILD
_ RAVFS2 TVFBLKT_BLKLST_TMP RI - CHILD
_ RAVFS2 TVFCANC_CANC_REQST RI - CHILD
_ RAVFS2 TVFDACC_DEBIT_ACC RI - CHILD

Hello,

If someone asks a question about file-aid, it is good to provide a file-aid answer.

As most systems to not have file-aid/db2 it is best not to provide solutions that require this product to general questions.

see below screens for more help:

the help/answer will be completely useless if the TS does not have the product/tool You are suggesting

look in sysibm.sysrels (if the relationship is documented in DB2)

Dick/enrico,

I agree that the help/answer given by me is completetly useless if the TS does not have DB2 fileaid. But DB2 fileaid is a common product which most of the company (around 95 %) have whoever is using IBM DB2. Also I am suggesting one of the way to find a solution for the user's problem without any concern to what the user have on thier site.

In mainframe world, there are different ways to handle everything which are site specific, so if we will think more about them we won't to be able to help the people.

Hello,

But DB2 fileaid is a common product which most of the company (around 95 %) have whoever is using IBM DB2.

Where did you get this statistic? Compuware would surely be happy if their fileaid/db2 product was licensed at 95% of the organizations that have db2

In mainframe world, there are different ways to handle everything which are site specific, so if we will think more about them we won't to be able to help the people.

Almost everything (except a product specific question) can be answered by some "standard" solution (see the suggestion from GuyC). Most situations do not require some site-specific product.

What are the different version of DB2 are available for mainframes since inception?
Please give me the list of DB2 versions till date. (Also I'm not clear about the tem DB2 UDB - is it related to mainframes DB2)?