100 likes | 290 Views
DB2 on Volvo wwwit.volvo.se/db2 db2@volvo.com. Issuer : DB-Team 2540 Issued : 2002-02-28. 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
E N D
DB2 on Volvo wwwit.volvo.se/db2db2@volvo.com Issuer : DB-Team 2540 Issued : 2002-02-28
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 IT Mainframe Sites with DB22002-03 Greensboro Gothenburg X Lyon Gent
Volvo It Mainframe Sites with DB22002-12 X Greensboro GDO Gothenburg X X Lyon Gent
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
Databases Tablespaces Tables Index Plans Packages Plan w. Pklist %Plan w. Pklist 2001 2002 3035 3185 43368 47605 89278 98114 62620 68548 81070 88882 128443 177660 34070 49124 42% 55% Number of objects (P/T/D -G/G/G)
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
DB2 other platforms • DB2/UX OnDemand, SAP Nobel Biocare • DB2/W2K WMQI