Volvo Information Technology DB 2 on Volvo wwwit

Volvo Information Technology DB 2 on Volvo wwwit. volvo. se/db 2@volvo. com 2540 OS/390 UNIX Issuer : DB-Team 2540 Issued : 2002 -02 -28 Win 2000 Volvo Information Technology Dept. 2540 Slide: 1

Volvo Information Technology 2540 / DB / 2540 u Part of Infrastructure Solutions u Global responsible for DB & TX infrastructure u SOE Standard Operation Environment u Second Level Support ® Local Operation is First Level u DB & TX Competence Center Consulting (primary new functionality) ® Review (primary projects that might have demands on infrastructure) ® u Employees 2003 -01 -17 16 / 5 / 1. 5 Volvo Information Technology Dept. 2540 Slide: 2

Volvo Information Technology Volvo IT Mainframe Sites with DB 2 2002 -03 Greensboro Gothenburg Lyon Volvo Information Technology Dept. 2540 Slide: 3 X Gent

Volvo Information Technology Volvo It Mainframe Sites with DB 2 2002 -12 X X Greensboro Lyon Volvo Information Technology Dept. 2540 Slide: 4 GDO Gothenburg X Gent

Volvo Information Technology DB 2 on Volvo u First Installation 1985 in Gothenburg u Consolidation of Trollhättan, Eskilstuna and Olofström u Mexpack to Göteborg, Gent, Greensboro u Data Sharing environment established year 2000 in Gothenburg u Lyon new DB 2 site after acquisition of RVI u Move of Gent, Lyon and Greensboro to Gothenburg (running in separate lpars) u Consolidation of DB 2 Subsystems into Data Sharing u Prepare for VCC-split u 48 Subsystem Volvo Information Technology Dept. 2540 Slide: 5

Volvo Information Technology Dept. 2540 Slide: 6

Volvo Information Technology DB 2 Objects Volvo Information Technology Dept. 2540 Slide: 7

Volvo Information Technology Number of objects (P/T/D -G/G/G) 2001 u Databases u 3035 u Tablespaces u 43368 u Tables u 89278 u Index u 62620 u Plans u 81070 u Packages u 128443 u Plan w. Pklist u 34070 u %Plan w. Pklist u 42% Volvo Information Technology Dept. 2540 Slide: 8 2002 3185 47605 98114 68548 88882 177660 49124 55%

Volvo Information Technology DB 2 Interfaces u TSO / IMS / CICS / CAF / RRSAF u Net. Data, web-publishing u USS Unix System Services , JDBC u DB 2 Connect / W 2 K JDBC, OLEDB u DB 2 Connect/Solaris-AIX JDBC u OTG Oracle Transparent Gateway /Solaris Volvo Information Technology Dept. 2540 Slide: 9

Volvo Information Technology DB 2 other platforms u DB 2/UX On. Demand, SAP Nobel Biocare u DB 2/W 2 K WMQI Volvo Information Technology Dept. 2540 Slide: 10