DB2 universal database certification guide / (Registro nro. 11852)

Detalles MARC
000 -Cabecera
Campo de control de longitud fija 07771nam a2200301 a 4500
003 - Identificador del Número de control
Identificador del número de control AR-sfUTN
008 - Códigos de información de longitud fija-Información general
Códigos de información de longitud fija 170717s1997 ||||| |||| 00| 0 eng d
020 ## - ISBN
ISBN 0130796611
040 ## - Fuente de la catalogación
Centro transcriptor AR-sfUTN
041 ## - Código de lengua
Código de lengua del texto eng
080 ## - CDU
Clasificación Decimal Universal 004.65 J251
Edición de la CDU 2000
100 1# - Punto de acceso principal-Nombre de persona
Nombre personal Janacek, Calene
245 10 - Mención de título
Título DB2 universal database certification guide /
Mención de responsabilidad Calene Janacek, Dwaine Snow.
250 ## - Mención de edición
Mención de edición 2nd
260 ## - Publicación, distribución, etc. (pie de imprenta)
Lugar de publicación, distribución, etc. Upper Saddle River, New Jersey :
Nombre del editor, distribuidor, etc. Prentice Hall,
Fecha de publicación, distribución, etc. 1997
300 ## - Descripción física
Extensión 770 p.
336 ## - Tipo de contenido
Fuente rdacontent
Término de tipo de contenido texto
Código de tipo de contenido txt
337 ## - Tipo de medio
Fuente rdamedia
Nombre del tipo de medio sin mediación
Código del tipo de medio n
338 ## - Tipo de soporte
Fuente rdacarrier
Nombre del tipo de soporte volumen
Código del tipo de soporte nc
505 80 - Nota de contenido con formato
Nota de contenido con formato CONTENIDO<br/>1. Product Overview 1<br/>DB2 Universal Database - The Scalable Database 2<br/>DB2 Products 2<br/>DB2 Universal Database (UDB) 4<br/>DB2 UDB Personal Edition 4<br/>DB2 Workgroup Edition 5<br/>DB2 Enterprise Edition 7<br/>DB2 Universal Database Enterprise-Extended Edition 8<br/>DB2 Connect 9<br/>DB2 Connect Personal Edition 10<br/>DB2 Connect Enterprise Edition 11<br/>DB2 Developer's Edition 12<br/>Licensing Scenarios 15<br/>DB2 Client/Server Environment 20<br/>Supported Communication Protocols 20<br/>DB2 Resource Usage 21<br/>Features and Functions 21<br/>DB2 Universal Database Administrator's Tools 24<br/>The Control Center 25<br/>The SmartGuides 27<br/>The Command Line Processor (CLP) 31<br/>Summary 33<br/>Questions 34<br/>Answers 36<br/>2. Getting Started and Connected 37<br/>Product Installation 38<br/>Intel Installation 38<br/>UNIX Installation 47<br/>DB2 Client Installation 56<br/>The DB2 Environment 61<br/>DB2 Profile Registry 61<br/>Environment Variables 63<br/>Using the Command Line Processor 64<br/>DAS and DB2 Instances 66<br/>DB2 Administration Server (DAS) Instance 66<br/>DB2 Instances 68<br/>Creating the Sample Database 72<br/>Summary 77<br/>Questions 78<br/>Answers 79<br/>Exercises 80<br/>3. Controlling Data Access 85<br/>Security 86<br/>Overview of Security 86<br/>Authentication 87<br/>Authorization Levels 91<br/>Security Considerations 95<br/>DB2 Privileges (Data Control Language) 97<br/>Database Object Privileges 97<br/>Establishing a DB2 Client/Server Connection 107<br/>Configuring a DB2 UDB Server 108<br/>DB2 Directories 116<br/>DB2 Discovery 120<br/>Generating a Server Access Profile 124<br/>Configuring DB2 Clients 124<br/>Using the Client Configuration Assistant 126<br/>Configuring a Connection to a DB2 Database 133<br/>Instance Administration 148<br/>Summary 153<br/>Questions 154<br/>Answers 157<br/>Exercises 158<br/>4. Using SQL 165<br/>Understanding Database Objects 166<br/>Data Types 166<br/>DB2-Supplied Data Types 167<br/>Large Objects (LOBs) 167<br/>String Data Types 170<br/>Numeric Data Types 171<br/>Datetime Data Types 173<br/>User-Defined Data Types 175<br/>Code Page Considerations 179<br/>Selecting the Correct Data Type 181<br/>DB2 Certification Database Design and Implementation 182<br/>Tables 191<br/>Using SQL Data Definition Language (DDL) 200<br/>Creating a DB2 Database 202<br/>Views 203<br/>Indexes 208<br/>Data Manipulation Language (DML) 212<br/>Data Retrieval (SELECT) 212<br/>Selecting Columns from Multiple Tables 218<br/>DB2 Functions 226<br/>Data Modification (INSERT/UPDATE/DELETE) 246<br/>Removing Data 250<br/>View Classification 254<br/>Business Rules 258<br/>User-Defined Defaults 258<br/>Check Constraints 259<br/>Triggers 261<br/>Advanced SQL 265<br/>Recursive SQL 265<br/>Outer Join 268<br/>OLAP Features 272<br/>Advanced Case Expressions 277<br/>Summary 280<br/>Questions 281<br/>Answers 283<br/>Exercises 284<br/>5. Database Concurrency 295<br/>Concurrency 296<br/>Concurrency Considerations 296<br/>Lost Update Problem 297<br/>Uncommitted Read 301<br/>Non-Repeatable Read 301<br/>Phantom Read Problem 303<br/>Isolation Level 304<br/>Uncommitted Read 305<br/>Cursor Stability 305<br/>Read Stability 305<br/>Repeatable Read 306<br/>Choosing an Isolation Level 306<br/>Locking 306<br/>Lock Attributes 307<br/>Lock Conversion 309<br/>Lock Escalation 310<br/>Lock Wait Behavior 311<br/>Summary 313<br/>Questions 314<br/>Answers 314<br/>Exercises 315<br/>6. Data Placement 321<br/>Containers 322<br/>Table Spaces 322<br/>Extents 324<br/>System Managed Storage (SMS) Table Spaces 325<br/>Database Managed Storage (DMS) Table Spaces 327<br/>Planning a Table Space Environment 330<br/>Creating Table Spaces 336<br/>Performance Considerations 345<br/>Buffer Pool 345<br/>Extent Size 346<br/>NUM_IOSERVERS 347<br/>I/O Prefetch 347<br/>Page Cleaners 348<br/>System Catalogs in DB2 349<br/>Managing Table Spaces 353<br/>States of Table Spaces 361<br/>Summary 363<br/>Questions 364<br/>Answers 366<br/>Exercises 367<br/>7. Data Management 379<br/>Populating Tables 380<br/>The LOAD Utility 380<br/>Using The LOAD Utility 383<br/>Syntax of the LOAD Command 386<br/>The IMPORT/EXPORT Utility 402<br/>The EXPORT Utility 403<br/>The IMPORT Utility 410<br/>Data Maintenance 414<br/>Analyzing Data's Physical Organization: REORGCHK 415<br/>Table Reorganization: REORG 420<br/>RUNSTATS 425<br/>The REBIND Utility 430<br/>Data Maintenance Process 431<br/>Modelling a Production Environment 432<br/>User Maintenance 434<br/>Fenced and Not Fenced Procedures and Functions 434<br/>Database Recovery 438<br/>Use of Log Files 439<br/>Types of Logging 443<br/>Backup and Restore 447<br/>Restore Database SmartGuide 462<br/>Summary of Backup/Restore Consideration 473<br/>The QUIESCE Command 475<br/>The Recovery History File 476<br/>Administration Tools for Data Maintenance 479<br/>The Script Center 480<br/>The Journal 483<br/>Data Replication 487<br/>Summary 490<br/>Answers 495<br/>Exercises 496<br/>8. Database Monitoring and Tuning 503<br/>Monitoring Methods 504<br/>Obtaining Database Access Information 504<br/>Explain Facilities 504<br/>Query Compilation 505<br/>Gathering Explain Data 508<br/>Examining EXPLAIN Data 513<br/>Database Monitoring 521<br/>Event Monitoring 531<br/>Visual Performance Monitors 538<br/>Performance Monitor 542<br/>DB2 Governor 550<br/>Performance Issues 551<br/>Configuring Database Resources 553<br/>DB2 Sorting Methods 558<br/>DB2 Server Resources 561<br/>Query Parallelism 562<br/>Performance Tuning Scenario 568<br/>Diagnostics and Problem Determination 571<br/>Error Messages and SQL Codes 571<br/>Tracing Problems in DB2 Universal Database 577<br/>Database Analysis and Repair Tool 581<br/>Summary 585<br/>Questions 586<br/>Answers 591<br/>Exercises 593<br/>9. DB2 Application Programming 597<br/>DB2 Application Development Environment 598<br/>Client/Server Platform 598<br/>Choosing a DB2 Programming Method 601<br/>Static Embedded SQL 601<br/>Dynamic Embedded SQL 602<br/>Call Level Interface (CLI) 603<br/>DB2 Application Programming Interfaces (APIs) 604<br/>Accessing Data from an Application 606<br/>Using Schemas 606<br/>Using an Alias 607<br/>Creating Packages 608<br/>Binding Applications 611<br/>Binding Utilities 615<br/>Parts of a DB2 Embedded Static SQL Application 617<br/>Host Variables 617<br/>Indicator Variables 626<br/>Using Cursors 631<br/>Handling Application Termination 638<br/>Interrupt Handling 638<br/>Large Objects 640<br/>Direct LOB Reference 640<br/>Reference by LOB Locator 641<br/>LOB File Reference Variables 644<br/>Unique Keys and Referential Integrity 646<br/>Online Analytical Processing 648<br/>STAR Schemas 648<br/>OLAP Indexes 650<br/>Dynamic Bitmap Index ANDing 650<br/>STAR Joins 651<br/>OLAP SQL 653<br/>Summary 654<br/>Questions 655<br/>Answers 668<br/>Exercises 671<br/>10. DB2 Advanced Application Programming 673<br/>Writing Dynamic Programs 674<br/>First Look at Dynamic SQL 675<br/>Dynamic SQL Phases 677<br/>Types of Dynamic SQL Statements 680<br/>Dynamic SQL - Callable SQL Interfaces 685<br/>ODBC vs CLI 686<br/>Embedded Dynamic vs Call Level Interface 687<br/>Setting Up a CLI Development Environment 687<br/>Stored Procedures 691<br/>User Defined Functions 692<br/>Support For Java Programming 696<br/>Compound SQL 697<br/>Summary 699<br/>Questions 700<br/>Answers 708<br/>Exercises 711<br/>Appendix A - Test Objectives<br/>DB2 UDB V5 Fundamentals (503) 713<br/>Appendix B - Test Objectives<br/>DB2 UDB V5 Database Administration (504) 717<br/>Appendix C - Test Objectives<br/>DB2 UDB V5 Application Development (505) 721<br/>Appendix D - DB2 Tools and Utilities 725<br/>Appendix E - DB2 Example Source Code 727<br/>Index 757<br/>CD-ROM Installation
650 ## - Punto de acceso adicional de materia - Término de materia
Término de materia BASES DE DATOS
650 ## - Punto de acceso adicional de materia - Término de materia
Término de materia DB2
650 ## - Punto de acceso adicional de materia - Término de materia
Término de materia DATABASE MANAGEMENT
700 1# - Punto de acceso adicional - Nombre de persona
Nombre personal Snow, Dwaine
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Tipo de ítem Koha Libro
Esquema de clasificación Clasificación Decinal Universal
Existencias
Estado Estado perdido Estado de conservación Tipo de préstamo Biblioteca Biblioteca Fecha de adquisición Número de inventario Total Checkouts ST completa de Koha Código de barras Date last seen Precio efectivo a partir de Tipo de ítem Koha
      Sólo Consulta Facultad Regional Santa Fe - Biblioteca "Rector Comodoro Ing. Jorge Omar Conca" Facultad Regional Santa Fe - Biblioteca "Rector Comodoro Ing. Jorge Omar Conca" 02/02/2018 8399   004.65 J251 8399 02/02/2018 02/02/2018 Libro