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 the purpus of the chain and setll and setgt ?

2 Answers   Four soft,


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

2 Answers   Four soft,


Last statement of any RPG pgm is LR?

5 Answers  


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

1 Answers  


What is the interactive job?

0 Answers  






How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?

3 Answers  


what is open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,


There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.

2 Answers  


how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,


When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 Answers  


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

5 Answers   Infosys,


how to update physical files using normal logical file

4 Answers  


Categories