doyoudb2

DB2 UDB for LUW (Linux, Unix and Windows)

 
  • Increase font size
  • Default font size
  • Decrease font size
SAP Related - Tips & Tricks

Multiple DB2 9 installations for SAP on Linux and Unix

Friday, 21 November 2008 13:53 Ravi Khandelwal
E-mail Print PDF
Out of the many enhancements of DB2 9 for LUW, an interesting one is the ability to install multiple copies of DB2 software of the same server. Till v8 the db2 installation path was hard coded and as a result only one copy of db2 software was allowed.

Write comment (2 Comments)
Read more...
 

DB2 CLI driver (for SAP DB2 DBAs only)

Tuesday, 12 August 2008 14:17 Ravi Khandelwal
E-mail Print PDF
User Rating: / 1
PoorBest 

If you are a DB2 DBA supporting SAP and your SAP system is BASIS 7.0 SR2 or lower, then you would have a "db2 runtime client" installed locally on each and every SAP application server. This means that you also have a db2 instance and a OS user on each application server.

This kind of configuration adds a lot to your maintenance work. Whenever you do a fixpack upgrade, you have got to apply the fixpack on all the application server (not forgetting a failvoer server or two - which incidentally many forget). Further you have to maintain all those db2instances and the OS users on the application servers.

Write comment (0 Comments)
Read more...
 

ONLINE_TABLE_MOVE Stored Procedure for SAP DB2 DBAs

Friday, 18 July 2008 13:47 Ravi Khandelwal
E-mail Print PDF
User Rating: / 3
PoorBest 
This post is for those DB2 DBAs who are supporting SAP environments. At various times SAP DB2 DBAs need to move tables in db2 from one tablespace to another. Someone who has worked in a SAP production environment will know that many of the tables become very large and hard to manage. It becomes even more difficult to get a downtime for long running maintenance tasks.

Welcome the ONLINE_TABLE_MOVE stored procedure. With a few restrictions it works wonderfully to move tables while the system is up and running. It can even be used to deep compress tables without having to run an offline REORG on them. This is most useful if you have tables spanning hundreds of gigabytes and can’t afford the maintenance window to do the offline compression.
Write comment (2 Comments)
Read more...
 

ERD for SAP Data classes and DB2 LUW Tablespaces

Thursday, 26 June 2008 13:47 Ravi Khandelwal
E-mail Print PDF
For DBAs working on SAP environment it becomes mandatory to have some understanding of the SAP tables in their database system. In a SAP environment when you create/drop tables and tablespaces you need to make sure that corresponding changes get recorded in the underlying SAP tables otherwise SAP will have trouble locating these objects.

The recommended way of doing it is using transaction db02 from SAP. An alternative way of doing is manipulating the SAP tables which store the data class definitions.
Write comment (0 Comments)
Read more...
 


Search Site

Subscribe

Enter your email address to receive new posts directly in your Inbox:

Relax! We hate SPAM as much as you do.

Categories

Sign In/Register

Syndicate Feeds - Subscribe