Diary of a Confused DBA…..

December 4, 2009

Tuning SAP…Is spool configured correct?

Filed under: Diary, SAP and Tuning, Tech-Manage — Tags: , , , , , , — soumen @ 7:20 pm

A couple of days back, when we were learning SAP spool configuration, this thought strike in my mind. What is the maximum effected area, where some small tweaks in the spool configuration can help business process.

The most sensitive are in a live business is the logistics. The raw material coming in and the finished goods going out, this actually holds the key of success.  Efficiency of business process in this segment gives you better running of business. And when you are running SAP as tool to accomplish your business processes, importance should lie on its ability of running faster with accuracy. The logistics process is always associated with some mandatory documents like invoices, excise and necessary tax papers which accompanies with the finished goods carrying vehicles.  And these documents need to printed and printed easily and faster.

So, it is apparently clear, in cases where the rates are very high, a tuned printing, which may only saving 20 secs, can became vital, very vital and life saver. So what we do need to here?

I think it is always better to use the location of TemSe to the file system instead of the database. This will always gives better performance because, because the additional headache of querying the spool data from database, and then creating the output request will be eliminated. The big is your data base is the more this will be efficient.  How this can be accomplished? A simpler way doing this by changing the TemSe location from Database to file system. The parameter used for this purpose is rspo/storage_location. We need to provide a value G here, which will then save the spool request to global directory additionally specified by the profile parameter rsts/files/root/G. An alternate value L can also be used, which makes the things much faster but then we need to ensure that generating, processing and spool work process is running on the same server. Because this time the spool is generated locally to the spool server. If someone is having the load balancing configured then it is better to avoid the value.

There are the other path also by changing the individual storage location of an output device in transaction SPAD. And this is most important. In a running business setup, it is better to define some spool devices for those points (highly important in the perspective of logistics, like weigh-bridge, the material in gate as the finished goods out gates. Then apply the alternate storage location for these devices.

Two important SAP notes in this regard are ….

  1. Note 20176 – Where is the spool request saved?
  2. Note 821519 – Front-end printing with control technology

December 2, 2009

SAP with MAXDB

Filed under: Diary — Tags: , , , — soumen @ 1:51 pm

This is a complete new thing to me, in the Basis training with SAP, we were geting trained on installation with Max DB. This is a nice experience, and add too this we did a small trouble shooting also yesterday….Our installation got hanged during import of JAVA export/repository. On checking thru MaxDB admin console, I came to know the the log files getting full and we added one more log file.

This solved our issue and we were thru with the installation. Another major observation, that it has not asked for database installation part separately, as it is used to in case of installation with oracle on Linux. In fact I was unable to fill the database installation when it happened. Mostly might be because of MaxDB is very small database or may be because of installation was done on Windows platform…….

November 23, 2009

Todays learning

Filed under: Diary — soumen @ 8:39 pm

Today learning the function of the ICM, and ITS…Good stuff…

November 21, 2009

Some editorial job done…

Filed under: Diary — soumen @ 6:13 pm

Today I got a high fever, I am supposed to do my revision study on TADM10-1 but simply do not like it to do. Facing severe body pain and taken Combiflam tabs, but yet do not get any relief.

I am really very very upset for this health problem, so only revised pages for SAP tuning in my blog, making it more navigable.

November 20, 2009

Redo – Learning/Training.

Filed under: Diary — soumen @ 4:44 am

After so many months of self learning and on job learning and so on and so forth, I joined a classroom training of  SAP Basis. So many new things I learning… My way of looking into SAP technology getting a new dimension…..And this is refreshing…….

« Newer PostsOlder Posts »

Blog at WordPress.com.