Transcript DB2 on Volvo

Volvo Information Technology
DB2 on Volvo
wwwit.volvo.se/db2
[email protected]
2540
OS/390
UNIX
Issuer : DB-Team 2540
Issued : 2002-02-28
Win2000
Volvo Information Technology
Dept. 2540
Slide: 1
Volvo Information Technology
2540 / DB / 2540
 Part of Infrastructure Solutions
 Global responsible for DB & TX infrastructure
 SOE Standard Operation Environment
 Second Level Support

Local Operation is First Level
 DB & TX Competence Center
Consulting (primary new functionality)
 Review (primary projects that might have demands on
infrastructure)

 Employees 2003-01-17 16 / 5 / 1.5
Volvo Information Technology
Dept. 2540
Slide: 2
Volvo Information Technology
Volvo IT Mainframe Sites with DB2
2002-03
Greensboro
Gothenburg
Lyon
Gent
X
Volvo Information Technology
Dept. 2540
Slide: 3
Volvo Information Technology
Volvo It Mainframe Sites with DB2
2002-12
X
X
Greensboro
Lyon
Volvo Information Technology
Dept. 2540
Slide: 4
GDO
Gothenburg
Gent
X
Volvo Information Technology
DB2 on Volvo
 First Installation 1985 in Gothenburg
 Consolidation of Trollhättan, Eskilstuna and Olofström
 Mexpack to Göteborg, Gent, Greensboro
 Data Sharing environment established year 2000 in
Gothenburg
 Lyon new DB2 site after acquisition of RVI
 Move of Gent, Lyon and Greensboro to Gothenburg
(running in separate lpars)
 Consolidation of DB2 Subsystems into Data Sharing
 Prepare for VCC-split
48 Subsystem
Volvo Information Technology
Dept. 2540
Slide: 5
Volvo Information Technology
Volvo Information Technology
Dept. 2540
Slide: 6
Volvo Information Technology
DB2 Objects
35000
30000
25000
DB
TS
20000
TB
IX
PL
PK
15000
10000
PLPK
5000
0
1995
Volvo Information Technology
Dept. 2540
Slide: 7
1998
1999
2000
2001
2002
Volvo Information Technology
Number of objects (P/T/D -G/G/G)
2001
 Databases
 3035
 Tablespaces
 43368
 Tables
 89278
 Index
 62620
 Plans
 81070
 Packages
 128443
 Plan w. Pklist
 34070
 %Plan w. Pklist
 42%
Volvo Information Technology
Dept. 2540
Slide: 8
2002
3185
47605
98114
68548
88882
177660
49124
55%
Volvo Information Technology
DB2 Interfaces
 TSO / IMS / CICS / CAF / RRSAF
 Net.Data, web-publishing
 USS Unix System Services , JDBC
 DB2 Connect / W2K JDBC, ODBC, OLEDB
 DB2 Connect/Solaris-AIX JDBC
 OTG Oracle Transparent Gateway /Solaris
Volvo Information Technology
Dept. 2540
Slide: 9
Volvo Information Technology
DB2 other platforms
 DB2/UX
OnDemand, SAP Nobel Biocare
 DB2/W2K WMQI
Volvo Information Technology
Dept. 2540
Slide: 10