DB2 universal database certification guide / (Registro nro. 11852)
[ vista simple ]
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 |
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 |