DB2 on Volvo
Download
Report
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