Currently, IBMs DB2 is the most powerful database management software for large mainframe systems. Designed specifically for the Windows NT environment, the book starts with all the usual features, including Windows NT remote administration, security, and performance features. However, it goes well beyond that to present the whole new level of performance and functionality offered by this new version, including tips on how to maximize its excellent user interface. Packaged with the book is a CD-ROM containing original IBM DB2 product code.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Graduate
Illustrationen
XIII, 242 p. With CD-ROM.
Maße
Gewicht
ISBN-13
978-3-540-76200-3 (9783540762003)
Schweitzer Klassifikation
Introduction.-
Getting Started
: Installing DB2 on an NT Server. Installing SAMPLE. An initial test of SAMPLE (and introduction to the Command Center). What you should find if all has gone well.- The Control Center. Systems. Instances. Databases. Creating a filter. The objects in a database. Creating a database using the SmartGuide. Creating a table using the SmartGuide.- Installing a front-end tool to manipulate your data. Background. Overview. Choosing whether to work from the server or a workstation. Choosing and installing a front-end. Running the CAE - to install the software. Running the CCA on a workstation. Running the CCA on a server. Configuring the ODBC connection. Configuring the front-end to use the ODBC connection. Finally, manipulating the data with your chosen front-end.- Installing on the client.- Overview of the tools.- Creating Databases and Tables. T Table spaces and containers.-
Backup
: Backup and Recovery.-
Finer control of your
database
: Scheduling tasks. Triggers. Users, Authorities and Privileges. Schemas.-
Advanced bits that you really need to
know
: Performance and tweaking. Performance SmartGuide. Visual Explain. Where to look if things go wrong. User Definable Data types and Functions. Test Data
