DB2 LUW Table Partitioning in SAP OLTP Systems
Table partitioning is often used in data warehousing environments, but it offers also advantages in OLTP systems. A new tool provided by SAP helps you to partition some of the largest tables in a SAP installation with DB2 for Linux, UNIX, and Windows. Jun. 20, 2011
Comments:
1
Rank:
18356
Page Views:
635 (Stats updated nightly)
SAP on DB2 pureScale
DB2 pureScale, based on DB2 for Linux, UNIX and Windows, is a shared disk database cluster solution targeted at high availability and scalability. With the start of the SAP on DB2 pureScale pilot program SAP customers can use this new technology from IBM. Nov. 30, 2010
Comments:
0
Rank:
16580
Page Views:
906 (Stats updated nightly)
Dropped Table Recovery with SAP on DB2
Beginning with DB2 UDB V8.2 a feature called ‘dropped table recovery’ is available in DB2. This feature helps to recreate a single table and its data in case the table was dropped unintentionally. In this post I explain how dropped table recovery works, why it is normally switched off in SAP installations and how you can optionally enable it. Dec. 17, 2008
Comments:
0
Rank:
6501
Page Views:
3747 (Stats updated nightly)
DB2 Best Practices Papers
Recently IBM published various best practices papers about DB2 for Linux, UNIX, and Windows. Some of them are also relevant for SAP installations on DB2. Jun. 9, 2008
Comments:
0
Rank:
2956
Page Views:
5712 (Stats updated nightly)
DB2 Row Compression Revisited
Automatic dictionary creation in DB2 for Linux, UNIX and Windows 9.5 and how to compress existing tables without an offline REORG. Apr. 3, 2008
Comments:
10
Rank:
6997
Page Views:
3542 (Stats updated nightly)
New Tool for Activation of Large Record Identifiers in DB2 9 for Linux, UNIX and Windows
DB2 9 introduced Larger Record Identifiers (LRIDs) to overcome table size limits existing in DB2 UDB 8. While much is said already on this topic the actual enablement of a table for LRIDs is still a command-line task. I'd like to present here a scenario which explains why it might be a good idea to activate LRIDs for _all_ tables of your database - and how this can be achieved with a new ABAP based tool. Nov. 14, 2007
Comments:
3
Rank:
6947
Page Views:
3556 (Stats updated nightly)
IBM DB2: 'Who is who' in the SAP environment
Here is a puzzle: DB2 UDB DB6 MSS i5 Common Server VENDOR_DB2_UDB OS/390 DB4 Universal
Database ADA RS/6000 ORA z/OS LUW AS/400. If you
know all these terms and the relation between them don't read any
further. Feb. 8, 2007
Comments:
2
Rank:
5658
Page Views:
4059 (Stats updated nightly)
New Features in DB2 UDB V9 - Part 5
Besides native XML capabilities IBM DB2 Version 9 offers other interesting new functionality. This blogs examines the new features and their relevance for SAP environments. Dec. 5, 2006
Comments:
1
Rank:
3528
Page Views:
5216 (Stats updated nightly)
New Features in DB2 UDB V9 - Part 4
Besides native XML capabilities IBM DB2 Version 9 offers other interesting new functionality. This blogs examines the new features and their relevance for SAP environments. Sep. 5, 2006
Comments:
7
Rank:
2648
Page Views:
6010 (Stats updated nightly)
New Features in DB2 UDB V9 - Part 3
Besides native XML capabilities IBM DB2 Version 9 offers other interesting new functionality. This blogs examines the new features and their relevance for SAP environments. Jul. 7, 2006
Comments:
6
Rank:
3075
Page Views:
5597 (Stats updated nightly)
New Features in DB2 UDB V9 - Part 2
Besides native XML capabilities IBM DB2 Version 9 offers other interesting new functionality. This blogs examines the new features and their relevance for SAP environments. Jun. 2, 2006
Comments:
1
Rank:
5156
Page Views:
4270 (Stats updated nightly)
New Features in DB2 UDB V9 - Part 1
Besides native XML capabilities IBM DB2 Version 9 offers other interesting new functionality. This blogs examines the new features and their relevance for SAP environments. May. 10, 2006
Comments:
1
Rank:
4296
Page Views:
4734 (Stats updated nightly)
