Need to restore printer file Qpquprfil

Tags:
I have deleted printer file Qpquprfil accidentally.So i need to restore it again.I couldn't see anywhere in backup.Could you please help me here how to retrieve the printer file back in Iseries?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    I'll poke around a bit more. I took a look at ours and it looks the same as the Qsysprt file except for one thing. Qpquprfil has 48 record formats. Strange.. You could try creating a duplicate obj of qsysprt just rename it and make sure it goes into QSYS. Then try running a query and see what you get. 
    136,970 pointsBadges:
    report
  • ToddN2000
    Here is a copy of how the file is set up on our system. You could also try and create a CRTPRTF and set up a new one...
       2/04/20                Display File Description                       
     DSPFD Command Input                                                      
       File  . . . . . . . . . . . . . . . . . . . : FILE       QPQUPRFIL     
         Library . . . . . . . . . . . . . . . . . :            *LIBL         
       Type of information . . . . . . . . . . . . : TYPE       *ALL          
       File attributes . . . . . . . . . . . . . . : FILEATR    *ALL          
       System  . . . . . . . . . . . . . . . . . . : SYSTEM     *LCL          
     File Description Header                                                  
       File  . . . . . . . . . . . . . . . . . . . : FILE       QPQUPRFIL     
       Library . . . . . . . . . . . . . . . . . . :            QSYS          
       Type of file  . . . . . . . . . . . . . . . :            Device        
       Device type . . . . . . . . . . . . . . . . :            Printer       
       Auxiliary storage pool ID . . . . . . . . . :            00001         
     Device File Attributes                                                   
       Externally described file . . . . . . . . . :            Yes           
       File level identifier . . . . . . . . . . . :            1150805103822 
       Creation date . . . . . . . . . . . . . . . :            08/05/15      
       Text 'description'  . . . . . . . . . . . . : TEXT                     
       Spool the data  . . . . . . . . . . . . . . : SPOOL      *YES          
       Maximum devices . . . . . . . . . . . . . . :              1      
       User specified DBCS data  . . . . . . . . . : IGCDTA     *NO      
       DBCS capable  . . . . . . . . . . . . . . . :            No       
       Maximum file wait time  . . . . . . . . . . : WAITFILE   *IMMED   
       Share open data path  . . . . . . . . . . . : SHARE      *NO      
       Record format level check . . . . . . . . . : LVLCHK     *NO      
       Number of record formats  . . . . . . . . . :               48    
       User buffer length  . . . . . . . . . . . . :              378    
       Number of devices . . . . . . . . . . . . . :              1      
       Separate indicator area . . . . . . . . . . : INDARA     Yes      
       Coded character set identifier  . . . . . . : CCSID         37    
     Printer Attributes                                                  
       Device  . . . . . . . . . . . . . . . . . . : DEV        *JOB     
       Printer device type . . . . . . . . . . . . : DEVTYPE    *SCS     
       Page size                                     PAGESIZE            
         Length  . . . . . . . . . . . . . . . . . :                 66  
         Width . . . . . . . . . . . . . . . . . . :                132  
         Measurement Method  . . . . . . . . . . . :            *ROWCOL  
       Lines per inch  . . . . . . . . . . . . . . : LPI        6        
       Characters per inch . . . . . . . . . . . . : CPI        10         
       Front margin  . . . . . . . . . . . . . . . : FRONTMGN   *DEVD      
       Back margin . . . . . . . . . . . . . . . . : BACKMGN    *FRONTMGN  
       Overflow line number  . . . . . . . . . . . : OVRFLW      60        
       Fold records  . . . . . . . . . . . . . . . : FOLD       *NO        
       Degree of page rotation . . . . . . . . . . : PAGRTT     *AUTO      
       Hardware justification  . . . . . . . . . . : JUSTIFY      0        
       Print on both sides . . . . . . . . . . . . : DUPLEX     *NO        
       Defer Write . . . . . . . . . . . . . . . . : DFRWRT     *YES       
       Unprintable character action                  RPLUNPRT              
         Replace character . . . . . . . . . . . . :            *YES       
         Replacement character . . . . . . . . . . :            ' '   X'40'
       Print text  . . . . . . . . . . . . . . . . : PRTTXT     *JOB       
       Align page  . . . . . . . . . . . . . . . . : ALIGN      *NO        
       Control character . . . . . . . . . . . . . : CTLCHAR    *NONE      
       Channel values  . . . . . . . . . . . . . . : CHLVAL     *NORMAL    
       Fidelity . . . . . . . . .  . . . . . . . . : FIDELITY   *CONTENT   
       Printer quality . . . . . . . . . . . . . . : PRTQLTY    *STD       
       Form feed . . . . . . . . . . . . . . . . . : FORMFEED   *DEVD      
       Source drawer . . . . . . . . . . . . . . . : DRAWER     1          
       Output bin  . . . . . . . . . . . . . . . . : OUTBIN     *DEVD      
       Font                                          FONT                  
         Identifier  . . . . . . . . . . . . . . . :            *CPI       
         Point size  . . . . . . . . . . . . . . . :            *NONE      
       Character identifier  . . . . . . . . . . . : CHRID      *CHRIDCTL  
       Decimal format  . . . . . . . . . . . . . . : DECFMT     *JOB       
       Font character set  . . . . . . . . . . . . : FNTCHRSET  *FONT      
       Coded font . . . . . . . .  . . . . . . . . : CDEFNT     *FNTCHRSET 
       Table Reference Characters  . . . . . . . . : TBLREFCHR  *NO        
       AFP Chars . . . . . . . . . . . . . . . . . : AFPCHARS   *NONE      
       Page definition . . . . . . . . . . . . . . : PAGDFN     *NONE      
       Form definition . . . . . . . . . . . . . . : FORMDF     *NONE      
       Form type . . . . . . . . . . . . . . . . . : FORMTYPE   *STD       
       Pages per side  . . . . . . . . . . . . . . : MULTIUP    1          
       Reduce output . . . . . . . . . . . . . . . : REDUCE     *TEXT      
       Unit of measure . . . . . . . . . . . . . . : UOM        *INCH      
       Front side overlay  . . . . . . . . . . . . : FRONTOVL   *NONE      
       Back side overlay . . . . . . . . . . . . . : BACKOVL    *FRONTOVL  
       IPDS pass through . . . . . . . . . . . . . : IPDSPASTHR *DEVD     
       Convert line data . . . . . . . . . . . . . : CVTLINDTA  *NO       
       User resource library list  . . . . . . . . : USRRSCLIBL *DEVD     
       Corner staple . . . . . . . . . . . . . . . : CORNERSTPL *NONE     
       Edge stitch                                   EDGESTITCH           
         Reference edge  . . . . . . . . . . . . . :            *NONE     
       Saddle stitch                                 SADLSTITCH           
         Reference edge  . . . . . . . . . . . . . :            *NONE     
       Font resolution . . . . . . . . . . . . . . : FNTRSL     *DEVD     
       DBCS extension characters . . . . . . . . . : IGCEXNCHR  *YES      
       DBCS character rotation . . . . . . . . . . : IGCCHRRTT  *NO       
       DBCS characters per inch  . . . . . . . . . : IGCCPI     *CPI      
       DBCS SO/SI spacing  . . . . . . . . . . . . : IGCSOSI    *YES      
       DBCS Coded font . . . . . . . . . . . . . . : IGCCDEFNT  *SYSVAL   
     Spooling Description                                                 
       Spooled output queue  . . . . . . . . . . . : OUTQ       *JOB      
       Max spooled output records  . . . . . . . . : MAXRCDS        100000
       Spooled output schedule . . . . . . . . . . : SCHEDULE   *FILEEND  
       Copies  . . . . . . . . . . . . . . . . . . : COPIES       1 
       Expiration date for file. . . . . . . . . . : EXPDATE    *NONE      
       Page range to print                           PAGERANGE             
         Starting page . . . . . . . . . . . . . . :                     1 
         Ending page . . . . . . . . . . . . . . . :            *END       
       File separators . . . . . . . . . . . . . . : FILESEP      0        
       Hold spooled file . . . . . . . . . . . . . : HOLD       *NO        
       Save spooled file . . . . . . . . . . . . . : SAVE       *NO        
       Output priority (on OUTQ) . . . . . . . . . : OUTPTY     *JOB       
       User data . . . . . . . . . . . . . . . . . : USRDTA     *SOURCE    
       Spool file owner  . . . . . . . . . . . . . : SPLFOWN    *CURUSRPRF 
       User defined option . . . . . . . . . . . . : USRDFNOPT  *NONE      
       User defined data . . . . . . . . . . . . . : USRDFNDTA  *NONE      
       User defined object                           USRDFNOBJ             
         Object  . . . . . . . . . . . . . . . . . :            *NONE      
           Library . . . . . . . . . . . . . . . . :                       
         Object type . . . . . . . . . . . . . . . :                       
       To stream file  . . . . . . . . . . . . . . : TOSTMF     *NONE      
       Workstation customizing object  . . . . . . : WSCST      *NONE      
     Record Format List 
       (No information available) 
    136,970 pointsBadges:
    report
  • akilanudaya
    Thank you so much for the help Todd !!!

    I will create a new object and added in system.


    35 pointsBadges:
    report
  • ToddN2000
    Let us know if you still have an issue if the new file does not work. We can see if we can find another solution. If you work for a company that supports multiple systems there is another recovery option.  We have saved the object on one system then using FTP set it to our other and then restored the object. You just need to be a bit careful but it has worked for us.  
    136,970 pointsBadges:
    report
  • TheRealRaven
    QPQUPRFIL contains many formats used to print query results and query information. There may be more or less formats depending on OS version/release and installed query options, though I'm not aware of any.

    You should be able to restore from the install media. You might want to restore any query options, but PTFs should also be reapplied in that case.

    I don't have a server available right now, so I can't look for the possible locations.  Have you run searches using a high-authority profile?
    37,215 pointsBadges:
    report
  • akilanudaya
    Hi Realraven & Todd

    Thank you for the response!!

    I did not search using a high authority profile. Sorry  I am not sure what it is. I had created the printer file QPQUPRFIL using above file descriptions provided by Todd. Seems it is working and  i am getting query output in spool file but i have one issue when i checked the output in spool ,i could see multiple entries (duplicate) for my query output. I am not sure what parameter need to change to avoid duplicate entry in printer file.

    Do you have any idea which parameter of QPQUPRFIL create a duplicate entry in Spool output?

    Please help me here

    Thanks in advance!!
    35 pointsBadges:
    report
  • ToddN2000
    Does it create 2 separate dpool files or so you still see one in the OUTQ after printing?
    It may be the number od copies is set to 2 or more, or it may be getting overidden in the QRY or by a CL.

    The other possibility is it is going on sav after it prints and still showd in the OUTQ.

    Check the PRTF definition and see how these paeameters are set. 

    Spooling Description                                                 
       Spooled output queue  . . . . . . . . . . . : OUTQ       *JOB      
       Max spooled output records  . . . . . . . . : MAXRCDS        100000
       Spooled output schedule . . . . . . . . . . : SCHEDULE   *FILEEND  
       Copies  . . . . . . . . . . . . . . . . . . : COPIES       1 
       Expiration date for file. . . . . . . . . . : EXPDATE    *NONE      
       Page range to print                           PAGERANGE             
         Starting page . . . . . . . . . . . . . . :                     1 
         Ending page . . . . . . . . . . . . . . . :            *END       
       File separators . . . . . . . . . . . . . . : FILESEP      0        
       Hold spooled file . . . . . . . . . . . . . : HOLD       *NO        
       Save spooled file . . . . . . . . . . . . . : SAVE       *NO
    136,970 pointsBadges:
    report
  • akilanudaya
    It doesnt create two separate spool files. But it does create same spool file twice or multiple times  in OUTQ like a duplicate entry.
     I could see multiple entries  in spool which are came from same query name.

    Repeated for 7 times in my case for eg:  for query -name File1
    The spool file looks below

    Query name .... File1
    Query name .....File1
    .
    .
    .
    Query name ....File1

    Likewise repeated

    I have checked the mentioned parameters. It looks like same above 

    Save spooled file   *NO
    Copies.....1

    Rest of the parameters are same as above.
    35 pointsBadges:
    report
  • TheRealRaven
    Because it has multiple formats in the original, it's externally-described with DDS. It's more or less possible to extract all format attributes from a file description, but creating matching DDS won't be easy.

    Restoring or re-installing is really the only good way to go.
    37,215 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: