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

Sap Latest Interview Questions and practical problem solutions

Q-:How can we check the relevant developer trace as there will be so many
dev_w#.

Ans-:
1. Check the database for logs full
2. Check file systems - available disk space
3. Check relevant developer trace files for clues dev_w#

Q-:If you search for relevant SAP notes the ABAP Short Dump "SAPSQL ARRAY INSERT DUPREC" is also produced with Program bugs.

Ans-:

SAPSQL ARRAY INSERT DUPREC
This error means that a transaction / program was attempting to commit
information to the database that would result in a duplicate entry in a
table with primary key. Depending on when and where you are getting it it
can be caused by some SAP bugs in Physical Inventory Document Clearing,
number ranges being out of synchronization after a client copy etc.

Q-:
how to unlock client 000?

Ans-:

Set the parameter login/no_automatic_user_sapstar = 0 (Zero) in the instance profile and restart the system.
when you locked yourself. You can try using DDIC or
sap* with the master password that should give you access to client 000 and
you can unlock the locked user.
Just go to the Profile <\usr\sap\SID\SYS\profile> add parameter
login/no_automatic_user_sapstar and restart sap mmc once, after this you
can login with default password


Queries-:

I'm planning to do the installation for SAP ECC 6.0 on Windows Server 2008 R2 Standard with Database DB2 9.1.

Do I need to download the DB2 v9.5 or 9.7 from the service market place and start the Installation, which DB2 version is compatible with Windows Server 2008 R2 Standard (DB2 9.5 or DB2 9.7).

SPDD transport we got from development will not suit in Quality system as there will be many delta objects. In our Quality system many urgent corrections happened, so we are planning to import SPDD transport manually and then check delta objects and proceed further.


in this case you should by-pass the SPDD and SPAU steps and process them after the Patching is complete.

However as you have imported the request and are getting R/C=8 errors you really need to contact SAP
In case of delta objects as well you can use the procedure mentioned by me
as that will include the SPDD of the development system and then give you
the option during preprocessing phase to do the delta adjustments.

Please open a customer message with SAP support to resolve the issue as you
had already imported the SPDD tr.

Sap Related Queries And Problems Which You Face

- Is there any possibility to allow create queries in production environment by using transaction SQ01 when system is non-modifiable



-if you taken client export of production client from scc8 with sap all & and import this on QA client, after successfully import of STMS. when iexecute tcode scc7 "Post-Client Import Methods" and check scc3 after some time it got stuck on following error message . kindly advice what's wrong



- looking for SAP System copy tools instead of manual system copy . what is it?



Qus-:




indeed was simpler to copy the transport files in some temporary location and then remove them from the buffer.





sol- You need to release all the transport requests. Then you can continue applying the support packages.

point2-

If you do not need the requests delete the transport Requests from the import buffer of the QAS/PRD systems



Qus-:

I'm not able to install the SAPKH60301 into the system as well. Getting the error "No valid queue for SAP_APPL rel. 603"



Sol-: Use Tx SPAM and view the packages and see what Prerequisite packages are necessary.

qus-

After the offline backup weather I can take the incremental backup. For
offline backup I have shutdown the database and copied the datafiles, log
files, temp file and control file and started the target system database.
I have no catalog while taking the backup.Now, I need to take the
incremental backup from the point where i have taken the full online backup.




- weather in increment backup only control files and redolog file are enough too take backup or weather we have to take changed data files also

-

After offline backup weather I can take incremental backup by RMAN.

Sol-:

If you restore the full offline backup you can restore the subsequent redo log backups only as long as you have not started the database on the Target system.

point2-

If you have started the database it is no too late to to apply to apply log backups. You should have restored the database using the offline backup and performed a point-in-time recovery using the redo log backups before starting the database. Once you start the database it it too late to apply additional logs.

what is Sap

SAP, started in 1972 by five IBM employees in Germany, it is the world's largest inter-enterprise software company and the world's fourth-largest  software supplier.

 The original SAP  provide help to  customers with the ability to interact with a common corporate database for a wide range of applications.today many companies implement the sap in their organization to manage all their branches.

today the latest SAP applications, built around their latest R/3 system, provide the ability to manage financial, asset, and management, accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including windows 2000 and uses the  client/server model.

As of January 2007, SAP, a publicly traded company, had over 38,4000 employees in over 50 countries, and more than 36,200 customers around the world. SAP is turning its attention to small- and-medium sized businesses. recently  R/3 version was provided for IBM's as/400 platform.