IBM DB2 9, DB2 V8 manual IDFORE=60 LBACKOUT=NO, Mon=Yes

Page 32

DSN6LOGP DEALLCT=(1440),

MAXARCH=500,

MAXRTU=2,

*OUTBUFF=4000, * TWOACTV=YES,

*TWOARCH=YES

DSN6SYSP AUDITST=NO,

*ACCUMACC=5,

*CHKFREQ=10, CONDBAT=64, (>= MAXDBAT)

* CTHREAD=1900, (sum of TSO users + IDBACK) DLDFREQ=5,

*IDBACK=1800, 1.3 * (number of all SAP work processes+ RFCOSCOL alert threads*2)

IDFORE=60,

*LBACKOUT=NO,

*LOGAPSTG=100, * LOBVALA=1000000, * LOBVALS=50000,

MAXDBAT=64, 1.3 * (number of all SAP work processes) * MGEXTSZ=YES,

MON=YES,

* MONSIZE=500000,

*PCLOSET=25,

*PCLOSEN=15,

RLF=NO,

RLFTBL=01,

RLFERR=NOLIMIT,

RLFAUTH=SYSIBM,

ROUTCDE=(1,3,4,11), * SMFACCT=(1,2,3),

* SMFSTAT=(1,3,6),

STATIME=30,

STORMXAB=5,

STORTIME=180,

*SYNCVAL=30,

TRACSTR=NO,

TRACTBL=16, * URLGWTH=100, * URCHKTH=1

DSN6FAC *	DDF=AUTO,
*	CMTSTAT=INACTIVE,
Copyright 2006 IBM Solutions Technical Sales (STS)		12/18/2007Page 32 of 51
12/18/2007

Image 32

Contents Albert D. Rodi Trademarks VII General Preparation Steps What is new with SAP Web Application Server 7.0 ?What is new with SAP Web Application Server 6.40 ? DB2 DBA 12/18/2007Page 6 12/18/2007Page 7 12/18/2007Page 8 12/18/2007Page 9 II z/OS Hardware Preparation 12/18/2007Page 11 III AIX Hardware Preparation Required for High Availability ENQ/SCS Solution IV z/OS Software PreparationRequired Highly Recommended12/18/2007Page 14 12/18/2007Page 15 Class Nameiggcas 12/18/2007Page 17 DB2 Preparation MLMT=4 MAXCSA=0 DEADLOK=5,1 12/18/2007Page 20 System Timeout Term Longlog Drain Delay Drainwait Retry RetrydelayMaxro Drain ALLSapcl FAQ VI DB2 Related OSS Notes12/18/2007Page 24 AIX Software Preparation Highly Recommended for AIX Application ServersViii Windows Hardware/Software Preparation SAP Installation Preparation Forkcopycow Sample BPXPRMxx MemberMAXSHAREPAGES131072 Afinet Transport for TCP/IP Sample DB2 Dsnzparms DB2 = required/recommended value for SAPIRLMSWT=300, * LRDRTHLD=10 MAXKEEPD=8000, * MINSTOR=YES NPGTHRSH=10RECALL=YES RECALLD=120 RELCURHL=YES SYSOPR1=SYSOPRXLKUPDLT=TARGET DSN6ARVP ALCUNIT=TRK, CYL CATALOG=YESIDFORE=60 LBACKOUT=NO MON=YESAPPENSCH=EBCDIC MAXKEEPD=8000, * MINSTOR=YES MXDTCACH=128, * NPGTHRSH=10 SECQTY=100 PARTKEYU=YES RECALL=YES RECALLD=120PROTECT=NO MGEXTSZ=YES MON=YES IDFORE=60 IDXBPOOL=BP3 IMPDSDEF=NO IMPTSCMP=YESLBACKOUT=NO, * LOGAPSTG=100 LOBVALA=1GB LOBVALS=50GB TSQTY=720 TIMELEN=0 END XII TCP/IP ConnectivitySapinst SAP SID DR1DR11DBM1 DR11IRLMXIV Start PORTGBF8 XV Sample OSA-Express GB ConfigurationGateway DB2 Backup/Recovery Notes OSS Note Recover TABLESPACE/RECOVER IndexspaceStop DB2 12/18/2007Page 45 12/18/2007Page 46 Xvii SAP Automation And High Availability Solution NFS 12/18/2007Page 49 XIX Sample SMS Storage Group Assignments SYS SortSoftw HFS

DB2 V8, DB2 9 specifications

IBM DB2 is a family of data management products that provide powerful capabilities for managing large amounts of data. Among its various versions, DB2 9 and DB2 V8 stand out due to their advanced features and technologies that cater to both enterprise needs and modern database requirements.

DB2 9, also known as "Viper," was a significant release that brought substantial enhancements to the database management system. One of its standout features is its support for XML data. This version introduced a native XML storage architecture, allowing users to store, retrieve, and manage XML data efficiently. The advanced query capabilities for XML data made it easier to integrate both structured and unstructured information into applications.

Another notable aspect of DB2 9 is its enhanced security features. It introduced features like label-based access control, ensuring that sensitive data could be properly managed according to the security policies of an organization. This version also included a transparent data encryption mechanism, protecting data at rest without impacting performance.

DB2 V8, released prior to DB2 9, presented several key features that had a lasting impact on database technology. One of its major advancements was the introduction of pureXML, which laid the groundwork for handling XML data. DB2 V8 also provided improved performance through enhancements such as table partitioning, which allowed for more efficient data organization and retrieval.

Additionally, DB2 V8 emphasized high availability and disaster recovery, incorporating features like DB2 HADR (High Availability Disaster Recovery). This allowed organizations to ensure data continuity even in the event of system failures, a critical aspect for enterprise environments that rely on uninterrupted access to their data.

Both versions of DB2 leveraged advanced technologies such as multi-version concurrency control (MVCC), which enhanced transaction integrity and performance. Their ability to support various platforms, including Linux, UNIX, and Windows, demonstrated IBM's commitment to providing flexible solutions tailored to different environments.

In summary, both IBM DB2 9 and DB2 V8 established a strong foundation in the database management ecosystem. With features focused on XML data management, enhanced security, performance improvements, and high availability, these versions have equipped organizations with the tools necessary to handle contemporary data challenges efficiently and effectively. Their legacy continues to influence database technology today, highlighting IBM's enduring impact on data management solutions.