Wednesday, December 28, 2011

How SAP Table Reorganized | Create Background Job Tivoli or Sap server

Q-:
How is SAP Table Reorganized ? Should all the table included !
should it be online/offline?

Ans-: You can do table Reorg either online or offline.Please take note that the online reorganization will impact on system performance, therefore you need to run this when the system load is low.

If you are using Oracle, reorg can be done using BRTools or db13 too.Please have a look at SAP Note 646681(for oracle) .Below am giving the method to run this if it is oracle DB;
the procedure to perform reorganization using BR*Tools::
1. Run BRTOOLS. Choose Segement Management or run from
the command prompt brspace –f tbreorg.
2. Enter table name in Table names (table).
3. Choose Reorganize Tables.
4. Set the required option like new destination tablespace or set he parallel thread which will be used to perform reorganization. The more you set the thread, the faster your process will be. But his limited to the CPU specification in OS level.
5. Choose continue to start processing.
6. Check the detail log in s.tbr.

You can perform the following types of reorganization:

* Reorganize tables online and check tables for reorganisation
* Clean up tables after aborted reorganization
* Convert LONG and LONG RAW fields to CLOB or BLOB online
* Stop reorganization (command-line mode only)
* Suspend reorganization (command-line mode only)
* Resume reorganization (command-line mode only)

Q-:
How void a range of checks and reprint them at the same time. What is the T-code I would use? Is it FCH8?
Ans-: No, FCH8 is used for reverse check payment
You need to check with your FI consultants or ask this message in the SAP-ACCT group.

Q-: ECC 6.0 ABAP server. Enabled user defined CCMS monitoring for file system, job failures, etc,,. But Spool alerts not getting generated in Tivoli.

Ans-: You can use Tcode SM36 to create background job and SM37 to check it on
SAP server.

2-: ans
For Tivoli to alert you on Filesystem, Table space or jobs etc your Tivoli
team will need to configure the tivoli situations on Tivoli. You as a
BASIS administrator will need to assist in the initial installation. You
will be required to run a standard script provided by tivoli which creates
the tablespaces,user assign the requisite roles to the tivoli user in your
SAP database and then import a transport into your instances.
Once done there are certain config details which will be needed to be
provided to the tivoli team by the help of which tivoli will start
monitoring your instance and depending on the situation configured generate
the alert.

assume that Tivoli does read all the open alerts which are reported
in the monitor "rz20 -> Tivoli monitoring -> New Pok sap"

Please first check if this is done for RED and YELLOW alerts and
secondly please check if only spool alerts are missing because as you
can see in the attached screen shot this monitor is reporting alerts
for many other type of monitoring nodes. It is better I think only to
create a monitor for the background job and spool monitoring nodes and
use this monitor for Tivoli.

Q-:How to create background job ? it should be created in Tivoli server or SAP server?
Ans-: You can use Tcode SM36 to create background job and SM37

No comments:

Post a Comment

your comment will be visible after administrator approval