Home » 2012

Yearly Archives: 2012

How can we calculate archivelog size each day?

How can we calculate archivelog size each day/hour?
This is not a difficult idea for someone who work as DBA, I just wish more idea for discussion and sharing . Some Idea using V$LOG.BYTES and V$ARCHIVED_LOG.*
but I believe V$ARCHIVED_LOG view be able to help:
Archivelog size each day:

SQL> select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME) order by 1;

———- ———-
2011-02-12 71797.87
2011-02-13 75880.52
2011-02-14 73569.37
2011-02-15 76776.81
2011-02-16 73959.86
2011-02-17 69969.71
2011-02-18 74677.10
2011-02-19 75474.95
2011-02-20 77967.07
2011-02-21 67802.70

Archivelog size each hour:

SQL> alter session set nls_date_format = ‘YYYY-MM-DD HH24’;

Session altered. (more…)

Error “LIST_TOO_MANY_LPROS” when using SAPGUI for Java

Lately, I am facing some error “LIST_TOO_MANY_LPROS” when using SAPGUI for Java 7.20 rev 9 to access SAP ERP 6.0 EHp 5 with Basis release 702 SP 12 (KB70212). Then I search this on service.sap.com and found this useful SAP Notes  17447011.



Accessing Implementation Guide through SPRO in HTML & JAVA GUI results in Runtime error as LIST_TOO_MANY_LPROS

Other terms


Reason and Prerequisites

While accessing IMG through SPRO in HTML & JAVA GUI, it results into run time error as LIST_TOO_MANY_LPROS.
This is because of some method calls are failing to be implimented in JAVA and HTML GUI.

Manual Steps to be followed:
1. Enter T-Code ‘SPRO’.
2. Click on ‘Settings’..’User-Specific Settings’..’General’
3. Uncheck all the check boxes.
4. Restart the t-code ‘SPRO’.

By this, some of the Control features cannot be accessed,
but the IMG navigation is possible.
Now, I am able to access SPRO smoothly again.

How to do remote client copy ( SCC8 ) & How to do client transport( SCC9 )

Hope the below information helps.
HOW to do remote client copy ( SCC8 )
1. create the new client in the target system via tcode SCC4
2. log on to the traget client of the traget system with the user SAP* and password PASS
3. for the planned copy run, you must define the RFC connection between the R3 systems as the source client, if this has not already been
4. you should also protect the source client of the source system against changes during the copy. To do this, log on to the source system and
lock the source client : In scc4 (
change mode ), choose the option ” Currently locked Due to client Copy ”
5. you can start the copy in the target system. Execute tcode SCC9
6. using the profile, choose the data to be copied
7. choose the RFC connection. The source system and client are chosen automatically for the RFC connection
8. before the actual copy, test the RFC connection using the RFC system check. In addition to testing the connection, the R3 system releases
are checked.
9. start the copy in background ( in test mode )
10. check the status of the copy procedure from the target system. You can do this at any time by choosing Client Administration..tcode SCC3
11. start the copy in background ( in final mode )
12. check the status of the copy procedure…SCC3
NOTE : with a remote client copy, only the table data is moved, not the table definitions. If user-specific, client-dependent tables were created in
the source client, they are not automatically copied to the target client, and an error may be caused. It is the responsibility of the user to create
the necessary tables in the target client manually via SE11.
HOW to do client transport : ( SCC9 )
prerequisites : the source and target system must have the same R3 release. The R3 system can not checked the R3 release since there is no
connection between the
systems established.
1. create the target client in the target system via tcode SCC4
2. log on the source client in the source system with a user with transport authorization ( Not SAP* or DDIC )
3. using the client maintenance tool ( SCC4 ), lock the source client against changes
4. go to the client transport menu by choosing Tools > Administration > Administration > Client Transport > Client Export or transaction SCC9.
When you confirm your
selection, you are notified of which transport requests were created for this task.
KO – Client-independent
KT – client-dependent
KX – texts
5. check the logs created for the copy run via SCC3
To import the transports created into another R3 system :
1. copy the required files to the corresponding subdirectory of the local transport directory of the target system
2. on the operating system level, from the subdirectory bin of the local transport directory of the target system, execute the commands :
tp addtobuffer <request> <target system> client=<client>
tp import <request> <target system> client=<client>
3. the remaining file with the text elements requires different procedure. Log on to the target client of the target system and access the client
administration tool by selecting
Tools > Administration > Client Administration > Client Admin. Choose client Transport > Post-process Import. Select the request
<SID>KT<number of the request> and
execute it online or in background. This procedure copies and generates the client-dependent text elements.

STMS Status of Importing Queue (Request Does Not Match Component Version)

With Version SAP_BASIS 702 a new feature was added to the TMS system, tp was checking the component version of the transport which was released and the component version of the system where the transport was going to be imported. If there was a difference, this difference was highlighted in the import queue (transaction stms_import) and if you tried to import the transport, the import would stop with a warning message about the difference in the SAPCOMPONENT versions.
You have error import status “Request does not match component version”.

Set STMS  profile parameter : SP_TRANS_SYNC = OFF
This can be added via transaction STMS of the domain controller.
Call transaction STMS
Goto ‘Systems Overview’
Double click you wish to add the parameter to
Goto ‘Transport Tool’ tab
Goto ‘change mode’
Add SP_TRANS_SYNC to parameter column and OFF to value column
Save, activate and distribute

Related SAP Notes
1581638 SAP component checks no longer working in TMS
1577714 Transport requests in Check requirements phase

Bypass Maintenance Optimizer on SAP Solution Manager

We had to confirm each packages through Maintenance Optimizer. I’ve found the way to bypass maintenance optimizer:

go at http://service.sap.com/patches and add all patches you want to download basket

you can go into SE37
choose function module /TMWFLOW/MO_UI_BASKET_AUTHORIZ
click on EXECUTE
choose packages and click on CONFIRM

there ya go, you can download using SAP download manager… and avoid Maintenance Optimizer.

IBM DB2 10.1 has been supported by SAP

Finally, IBM DB2 10.1 has been supported by SAP. There are a lot of improvement whic had been done by IBM on DB2 10.1 such as Adaptive Compression (prior than Deep Compression which now mentioned as Static Compression), Log Compression, etc.

SAP has just certified DB2 10.1 this July 2012.

There are several SAP Notes need to be read and implement if you want to use DB2 10.1.

sapnote_0001700631_DB6: Using DB2 10.1 with SAP Applications

sapnote_0001701181_DB6: ABAP DDIC: Enhancements for DB2 10.1

sapnote_0001692571_DB6: DB2 10.1 Standard Parameter Settings

sapnote_0001365982_DB6: Current db6_update_db_db6_update_client script (V 27)

Right now, I also doing some research on this DB2 10.1 using SAP ERP 6 EHP 5.

Happy hacking, guys !!