how can i know logical file belongs to which physical file
without source?

Answers were Sorted based on User's Feedback



how can i know logical file belongs to which physical file without source?..

Answer / vinay pawar

No Its not the correct answer... if you do a DSPDBR on a
logical file it wont show you the name of the physical file
that it is based on. Rather you need to use DSPFD on the
logical file. DSPDBR on a physical file will show the names
of all the LF files based on that PF.

Is This Answer Correct ?    45 Yes 0 No

how can i know logical file belongs to which physical file without source?..

Answer / tim austin

if you enter dspfd tgi3500l1
you will get a display part of which is seen below which
will tell the name and location of the physical file. But
if you use smart naming convention as seen here you wouldnt
need any command because our shop ends all physical files
with pf and all logicals with l1 l2 l3 etc thereby
providing he answer in the file name

Files accessed by logical file PFILE
File Library LF Format
TGI3500PF CJTPRODDAT TGI3500L1

Is This Answer Correct ?    3 Yes 0 No

how can i know logical file belongs to which physical file without source?..

Answer / afnas

use DSPDBR command

Is This Answer Correct ?    14 Yes 31 No

Post New Answer

More DB400 Interview Questions

What is open data path?

0 Answers  


I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?

0 Answers  


What is the difference between access path and open data path?

0 Answers  


how to update physical files using normal logical file

4 Answers  


How to find the list of source physical files in a library?

0 Answers  






what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,


what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,


How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,


Which keyword is used both in subfile and subfile control record format of a DSPF?

8 Answers  


what is use of self join and which cases you will use this join

1 Answers   TCS,


CRTDTA AND CRTARA should be used along with?

2 Answers  


Q.1 how to implement the commitment control. 2.how to control commitment control from external program.

7 Answers   IBM,


Categories