sap spool administration

SAP SPOOL Administration

Spool Administration

      The spool profile parameter name is - rdisp\wp_no_spo      By using SPAD transaction code we can configure the printer in sap.
      In OS level spool request are stored in global directory usr\SAP\<SID>\sys\global      The storage location specific parameter name is - rdisp\store_location      This parameter has 2 values, they are global_G and database_DB.
     G means it stored in global   directory.
     DB means it stored in database     tables are "TST01"&"TST03"
      The spool request is also referred as TEMSE     TEMSE is used for temporary   sequential     objectsIn this all the requests will be stored      Access Method:-
     Access methods are 3 types     1.Local Access Method:- The spool process    and the spool host reside on the same system. Access method type L is used for     UNIX OS & C is used for Windows OS.
     2.Remote Access Method:- The spool process   and the spool host reside on two different systems. Access method type U is used for      UNIX OS & S is used for windows OS.
     3.Front End Method:- Access method P is      the printers are connected to end users   desktop do not configured to many front      end printers F and G.
      We can see all clients & users spool request T_code is SP01      We can see specific client and user spool request T_code is SP02      Default printers are SWIN,SAPWIN1. What does spool request contain ?
     Spool request contains   detailed information    regarding      printer model,      formatting to be done on the data to be      output.2. Where is the spool request stored ?
     The spool request that is     generated is   stored in the Temse(      temporary      sequential file)3. What are different Spool statuses and their significance?
     Spool requests will have      different      statuses like
     Completed ,Waiting, In   process,
     Printing ,Problem ,Error,     Archive,  Time4. Which work processes will create spool requests?
     Spool requests will be created     by dialog      or background      work      processes.     Please note that spool work   processes do   not create     spool      requests5. What is the difference between spool request and output request ?
     Spool request contains   detailed information    regarding      printer model,      formatting to be done on the data to be      output. Output      request contains all the      data in the format      that the printer   understands.     A spool work process formats the data specified in the    spool      request and    generates the output request.      Output    request is   also      termed as print     request.6. Which work process will create output request ?
     Output request will be created by spool      work processes.7. What is spool overflow ?     Spool request that got generated are stored in a temporary sequential file called Temse. Please note that these are stored in Temse because these are not stored permanently. The size of the Temse is limited by the parameter definition.     The default size of Temse is 32,000 and it can be increased till 2 billion. However, defining very high value can affect the database performance. Due to limited storage capacity of Temse, when this file got full, this throws an SAP      spool overflow error.     If this happens, customers could not print   from SAP. If you      check in SM21 and ST22 transactions, you may encounter some error log or dumps likeERROR IN SPOOL call : SPOOL OVERFLOWSPOOL_INTERNAL_ERROR     System internal error in the spool system8. How to troubleshoot spool overflow ?
     To resolve this spool issue, some of the     old spools can be deleted from the sap     system. Goto transaction SPAD. From the initial screen, navigate to Administration -> Clean_up_spool. Once you click this,      Spool Administration :   Delete old spool    requests screen will be displayed.     In that screen, you will be prompted to      choose requests for deletion like Old spool requests older than the maximum     set age Requests already printed All spool requests      and enter value for minimum age (in     days) text box.Select the check boxes as per the requirement (eg:  delete all requests      already printed     and minimum age in days equal to 30 days) and execute to     delete old     spool requests, which will    clear Temse and will resolve    spool over flow issue.     Apart from this there are     others ways of resolving spool      overflow issue. They are     1)Run the report RSPO0041     from SE38      transaction to      delete old spool    requests     2)Run the report RSPO0043 from     SE38 transaction, which checks      the Temse/spool consistency and  reorganizes  the spool.9. How to avoid spool overflow issue ?
     These reports RSPO0041 and    RSPO0043 should     be   scheduled as      background jobs     with      proper variants on a     periodic basis      which     avoids spool overflow issue.     You can try to increase the   spool numbers from default   32000      to a bit higher     value     but please note     donot set this too      high as it     may impact database      performance     Proactive monitoring check can     be made in     RZ20      transaction    to see how much     is the    fill level of spool      numbers.10.         How to check spool numbers ?
          To check spool numbers :      Goto RZ20 transaction,   navigate to SAP CCMS    Monitor Templates -> Spool    System.     Here you can check the status      of spool servers and the used      numbers   percentage of spool      numbers. If you find     that      used numbers is greater than      80%, you can   manually run      above     mentioned reports or     delete old spool    requests      from SPAD tcode as mentioned      earlier.11.         How to set the spool number in SAP ?
     Using Transaction SNRO (Number range    object maintenance) and object SPO_NUM,     you can set the spool number in an SAP system.     Once you provide object as SPO_NUM, click    on change icon. It      displays another    screen. In that screen, click on Number Ranges push button. It displays another   screen "Number range     for spooler      numbers". Click on change icon here and      set the   value of spooler(from number and to number) Please note   that a change request may be generated here based on the      client settings(if automatic recording of   changes is set in   SCC4 transaction of the client)12.         How to define storage location (Temse) of spool requests ?
     Every Temse object contains a header in      TST01 table and the actual object. This can be either stored in table TST03 or in file system. You can set a parameter rspo/store_location in RZ10 to define whether to store Temse objects      TST03     table or in filesystem.     If value G is set to this parameter, it      will be stored in file system and if it    is db it is stored in TST03 table.     Here are step-by-step instructions for managing your spool requests.      1. Run tcode --> se16-> TSP01     2. Select-->RQIDENT      3. Number of hits --> 3200     4. Execute --> F8     From here you can able to see how many spool request pending.     Then:     1. Run tcode -> se38 --> RSp00041 -->   execute      2. Select client (*)n --> for all client      3. All the pending spool deleted13.         User can't print       See if the user has proper authorization.      Check SAP user setup, check SPAD, check spools, check Unix queue or print queue at the OS level.
14.         Changing all printer hosts at a time?
     With this tip you can set or change the spool printing     host.   
     Here are the steps:      SPAD->OUTPUT DEVICES      CLICK ON PEN (Change Icone)      Go to Menu Utilities->For     Output Devices->Assign   Server.      This will ask you for Device Name, Old      Spool Server, New Spool Server.      You can give * for first two option and     select new     spool server at the end.      Click on [display list]     On next screen click on [convert].     This will change the spool    server on all displayed      printers.15.         We did a homogeneous system copy. We have around 700 printers installed in our source system. After the system copy, in our target system, how can we setup all printers at a time?There is a ABAP/4 program by which we can change the spool server for all devices at a glance. The program is "RSPO0067". This program requires following parameters:- Output device- Old spool server- New spool serverBy executing this we can change the spool server for all output devices or selected ones.16.         How to delete multiple spool requests?
     Execute the programme    "RSPO0041"     This report is "RSKREORG". It      removes   orphaned fax and telex messages, messages cancelled by the user in the spool output      controller before they were sent.
17.         ssHow can i print A3 format in SAP?     Go to tab "output attributes"          paper tray="paper tray3"          Tab="tray info"          Tray3="DINA3"

 SMSAP TOOL

-->SMSAP Tool version is 3.3
   Login to OS level with Ora<sid> and open vnc session.1> How to open a vnc session?     In command prompt(PUTTY)     > vncserver
          Then enter, It will open a vncserver like :1 ,:2, :3
with this number click on vnc software and mention the session number.In the opened new vncsession give command     > smsapgui &
It will prompt the SMSAPGUI     Here we can see Tabs     Monitor|Schedule|Backups/clones|History
-->click on Backups/clones-->Go to Repository & Right click on Repository                  & Open-->It will open all the hosts names-->Right click on Hostname which we want to open<SID>-->Right click on <SID> and open    It will open all the backups.
    Here we can schedule backup, delete the backup, check the backup which is failed depend on the failed log we can address to related team(database, storage, UNIX)
2> How to kill vncsession which we opened?     >vncserver -kill :1(session number)3> How to see hidden files in UNIX?     >ls -lart
     It will display all hidden and          unhidden files also.   Issues:-
     1.Error:SMSAP-13032can't      perform operation. Backup     restore.
   Oracle-00507:Can't find entry   for SID or database name in      /etc/oratab file on host     2. Unable to determine   permissions for file      /oracle/SID/oraarch/SIDarch/.d     bf Error: no such file are      directory