Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
DB2 for z/OS and OS/390 [[electronic resource] ] : ready for Java / / Bart Steegmans ... [et al.]
| DB2 for z/OS and OS/390 [[electronic resource] ] : ready for Java / / Bart Steegmans ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | xxiv, 334 p. : ill |
| Disciplina | 005.2/762 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico | Java (Computer program language) |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450234303321 |
| [S.l.], : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 for z/OS and OS/390 [[electronic resource] ] : ready for Java / / Bart Steegmans ... [et al.]
| DB2 for z/OS and OS/390 [[electronic resource] ] : ready for Java / / Bart Steegmans ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | xxiv, 334 p. : ill |
| Disciplina | 005.2/762 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico | Java (Computer program language) |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783396603321 |
| [S.l.], : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 for z/OS and OS/390 : ready for Java / / Bart Steegmans ... [et al.]
| DB2 for z/OS and OS/390 : ready for Java / / Bart Steegmans ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | xxiv, 334 p. : ill |
| Disciplina | 005.2/762 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico | Java (Computer program language) |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Summary of changes -- December 2004 -- Part 1 Introduction -- Chapter 1. A brief history of Java -- 1.1 From toaster to the enterprise -- 1.1.1 Java and the consumer electronics revolution -- 1.1.2 Accessing the data -- 1.1.3 The rise of the Internet server -- 1.1.4 The Internet and the enterprise -- 1.2 Java and the z/OS and OS/390 platforms -- Chapter 2. An introduction to Java 2 Enterprise Edition -- 2.1 The three technology editions for the Java 2 platform -- 2.2 Java 2 Platform, Enterprise Edition -- 2.3 Java 2 features -- 2.3.1 Object-oriented programming -- 2.3.2 Primitive data types -- 2.3.3 Garbage collection -- 2.3.4 Removal of pointers -- 2.3.5 No more GOTOs -- 2.3.6 Java Virtual Machine -- 2.4 Java application environments -- 2.4.1 Stand-alone Java applications -- 2.4.2 Java applets -- 2.4.3 Java Servlets -- 2.4.4 JavaServer Pages -- 2.4.5 JavaScript -- 2.4.6 Java Beans -- 2.4.7 Enterprise Java Beans -- Chapter 3. Accessing DB2 from Java -- 3.1 JDBC basics -- 3.1.1 JDBC driver types -- 3.1.2 The IBM DB2 Universal Driver for SQLJ and JDBC -- 3.2 Different ways to connect to a DB2 for z/OS and OS/390 -- 3.2.1 Direct (T2) connection to a local DB2 subsystem -- 3.2.2 Using the Type 4 driver to talk to a local DB2 for z/OS and OS/390 -- 3.2.3 Type 4 connectivity from a non-z/OS platform -- 3.2.4 Type 2 connectivity from a non-z/OS platform -- 3.2.5 DB2 for z/OS and OS/390 as a DRDA Application Requester -- 3.2.6 IBM z/OS Application Connectivity to DB2 for z/OS and OS/390 -- 3.3 Developing a Java application using JDBC -- 3.3.1 Connecting to a database -- 3.3.2 Using the DriverManager interface -- 3.3.3 Connecting using the DataSource API.
3.4 Accessing data using SQLJ -- 3.5 Using JDBC or SQLJ -- 3.5.1 SQLJ is easier to code -- 3.5.2 SQLJ catches errors sooner -- 3.5.3 SQLJ is faster -- 3.5.4 SQLJ provides better authorization control -- 3.5.5 SQLJ is more predictable and reliable -- 3.5.6 SQLJ allows for better monitoring -- 3.5.7 SQLJ Tooling -- 3.5.8 Use JDBC for flexible SQL statements -- 3.5.9 SQLJ/JDBC interoperability -- 3.6 Summary -- Part 2 Prerequisites and setup -- Chapter 4. Products and levels - Now and soon -- 4.1 Products and levels -- 4.1.1 Now -- 4.1.2 Soon -- Chapter 5. Setup -- 5.1 DB2 for OS/390 and z/OS V7 -- 5.1.1 Installing DB2 SQLJ/JDBC support -- 5.1.2 Installing the Universal Driver on a z/OS or OS/390 platform -- 5.1.3 Required DB2 for z/OS changes to enable the Universal Driver -- 5.2 Workload Manager (WLM) -- 5.3 Unix System Services -- 5.3.1 Setting up a USS session -- 5.3.2 Setting up the JDBC/SQLJ environment variables -- 5.4 DB2 Universal Driver - Setup for a Windows environment -- 5.5 WSAD setup -- 5.5.1 Using the data perspective -- 5.6 WebSphere for z/OS datasource setup -- 5.6.1 Log onto the WAS Administrative Console -- 5.6.2 Setting up system variables -- Part 3 Putting it all together -- Chapter 6. Getting started with JDBC -- 6.1 Creating the project -- 6.1.1 Loading the JDBC driver -- 6.1.2 Establishing the connection -- 6.1.3 Preparing an SQL statement for execution -- 6.1.4 Populating parameter markers -- 6.1.5 Executing the statement -- 6.1.6 Processing the result set -- 6.1.7 Cleaning up resources -- 6.2 Running the Hello application from WSAD -- 6.2.1 Creating the launch configuration -- 6.2.2 Setting up the classpath -- 6.2.3 Troubleshooting -- 6.3 Running the Hello application from Unix System Services -- 6.3.1 Exporting to a shared file system -- 6.3.2 Exporting via FTP -- 6.3.3 Running the program. 6.4 Running a Java program from a Windows command prompt -- 6.4.1 Compile the Java program (javac) -- 6.4.2 Run the Java program (java) -- 6.5 Debugging the application on the workstation -- 6.6 Remote debugging -- Chapter 7. JDBC revisited -- 7.1 INSERT, UPDATE and DELETE statements -- 7.1.1 INSERT -- 7.1.2 UPDATE -- 7.1.3 DELETE -- 7.2 NULL handling -- 7.3 Examining result sets -- 7.4 Database metadata -- 7.4.1 Information about the JDBC driver -- 7.4.2 Information about the database server -- 7.4.3 Information about database objects -- 7.5 Positioned UPDATE and DELETE -- 7.5.1 Positioned UPDATE -- 7.5.2 Positioned DELETE -- 7.6 Large objects (LOBs) -- 7.7 Scrollable cursors -- 7.8 A complete example: Poor man's SPUFI -- Chapter 8. Getting started with SQLJ -- 8.1 Creating the source file -- 8.2 Running the Hello application from WSAD -- 8.2.1 Creating the launch configuration -- 8.2.2 Specifying command line parameters -- 8.3 Running the Hello application from Unix System Services -- 8.4 Running the Hello application from MVS batch -- Chapter 9. The SQLJ program preparation process -- 9.1 Program preparation in other languages -- 9.2 Overview of the SQLJ program preparation process -- 9.2.1 The SQLJ translator -- 9.2.2 More about profiles -- 9.3 The DB2 profile customizer -- 9.3.1 Isolation levels -- 9.3.2 Why online checking is good for you -- 9.4 The DB2 profile binder -- 9.5 The DB2 profile printer -- 9.6 Preparing an application to use static SQL -- 9.6.1 Preparing SQLJ programs to use static SQL through WSAD -- 9.6.2 Doing it yourself - Manual program preparation for static SQLJ -- 9.6.3 Running your sqlj program locally on a DB2 for z/OS system -- 9.6.4 In summary -- Chapter 10. SQLJ tutorial and reference -- 10.1 The basic syntax of SQLJ statements -- 10.1.1 Executable statements -- 10.1.2 Iterator declarations. 10.2 Host variables and expressions -- 10.3 Null values -- 10.4 Data type mapping -- 10.5 Queries, iterators, and the assignment statement -- 10.5.1 Using positioned iterators -- 10.5.2 Using named iterators -- 10.5.3 SQLJ iterators versus cursors -- 10.5.4 Holdable iterators -- 10.5.5 Positioned UPDATE and DELETE -- 10.5.6 Calling stored procedures -- 10.6 Connection contexts -- 10.6.1 Setting up and using an implicit connection context -- 10.6.2 Why the connection context is important -- 10.6.3 Declaring a context class -- 10.6.4 Creating an instance of the context class -- 10.6.5 Specifying which connection instance to use -- 10.6.6 Using more than one context class -- 10.6.7 Summary of ConnectionContext methods -- 10.7 Execution contexts -- 10.8 Interoperability between JDBC and SQLJ -- 10.8.1 Converting a JDBC result set into an SQLJ iterator -- 10.8.2 Converting an SQLJ iterator into a JDBC result set -- Chapter 11. SQLJ revisited -- 11.1 Introduction -- 11.2 Creating the Employee class -- 11.2.1 Implementing attributes, accessors, and constructors -- 11.2.2 Implementing the constructor to create new employees -- 11.2.3 Implementing the insert() method -- 11.2.4 Creating a test driver -- 11.2.5 Verifying that the program worked -- 11.2.6 Implementing the findByPrimaryKey() method -- 11.2.7 Implementing the delete() method -- 11.2.8 Implementing the update() method -- 11.2.9 Implementing the findAll() method -- 11.2.10 Working with LOB data: The getPicture() and setPicture() methods -- Chapter 12. The DB2 Universal Driver -- 12.1 What the DB2 Universal Driver for SQLJ and JDBC is -- 12.2 Setting connection properties in the URL -- 12.3 Functionality enhancements -- 12.3.1 Scrollable cursor support -- 12.3.2 Batch updates -- 12.3.3 Improved security for DB2 authentication -- 12.3.4 Improved Java SQL error information. 12.3.5 Java API for Set Client Information (SQLESETI) -- 12.3.6 Java API for application monitoring -- 12.3.7 Native DB2 server SQL error messages -- 12.3.8 Multiple open cursors -- 12.3.9 SAVEPOINT support -- 12.3.10 Auto-generated keys -- Chapter 13. Performance topics -- 13.1 General performance recommendations -- 13.1.1 Use static SQL wherever possible -- 13.1.2 Turn auto commit off -- 13.1.3 Only retrieve/update columns as needed -- 13.1.4 Store numbers as numeric data types -- 13.1.5 Use DB2 built-in functions -- 13.1.6 Release resources -- 13.2 JDBC recommendation -- 13.3 SQLJ performance considerations -- 13.3.1 Use matching data types -- 13.3.2 Use positioned iterators, not named iterators -- 13.3.3 Always customize with online checking enabled -- 13.3.4 Check explain tables -- 13.3.5 Rebind packages regularly -- 13.4 System-level performance tuning -- 13.4.1 Tune the JVM heap size -- 13.4.2 Get the latest code and maintenance -- 13.4.3 Turn on DB2 dynamic statement caching -- Chapter 14. Error handling and diagnosis -- 14.1 Basic error handling -- 14.2 SQLCODE and SQLSTATE -- 14.3 Cleaning up resources -- 14.4 DB2 specific error handling -- 14.5 Tracing -- 14.5.1 Turning on tracing in the program -- 14.5.2 Turning on tracing using connection properties -- Part 4 Accessing DB2 from Web applications -- Chapter 15. Using Servlets to access DB2 -- 15.1 Creating the project -- 15.2 Creating the EmployeeList Servlet -- 15.2.1 Implementing the doGet() method -- 15.2.2 Testing the Servlet -- 15.2.3 Displaying the employee list -- 15.3 Running the completed EmployeeList Servlet -- 15.4 Creating the EmployeeDetail Servlet -- 15.5 Creating the EmployeePic Servlet -- 15.6 Putting it together -- 15.6.1 Modifying the EmployeeList Servlet -- 15.6.2 Modifying the EmployeeDetail and EmployeePic Servlets. 15.6.3 Using EmployeePicServlet from EmployeeDetailServlet. |
| Record Nr. | UNINA-9910823254403321 |
| [S.l.], : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 for z/OS and WebSphere [[electronic resource] ] : the perfect couple / / [Bart Steegmans ... et al.]
| DB2 for z/OS and WebSphere [[electronic resource] ] : the perfect couple / / [Bart Steegmans ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | San Jose, : IBM, International Technical Support Organization, c2005 |
| Descrizione fisica | xxiv, 332 p. : ill |
| Disciplina | 005.74 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450147103321 |
| San Jose, : IBM, International Technical Support Organization, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 for z/OS and WebSphere [[electronic resource] ] : the perfect couple / / [Bart Steegmans ... et al.]
| DB2 for z/OS and WebSphere [[electronic resource] ] : the perfect couple / / [Bart Steegmans ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | San Jose, : IBM, International Technical Support Organization, c2005 |
| Descrizione fisica | xxiv, 332 p. : ill |
| Disciplina | 005.74 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783528203321 |
| San Jose, : IBM, International Technical Support Organization, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 for z/OS and WebSphere : the perfect couple / / [Bart Steegmans ... et al.]
| DB2 for z/OS and WebSphere : the perfect couple / / [Bart Steegmans ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | San Jose, : IBM, International Technical Support Organization, c2005 |
| Descrizione fisica | xxiv, 332 p. : ill |
| Disciplina | 005.74 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction to DB2 for z/OS and OS/390 -- 1.1 Relational database management systems -- 1.2 The DB2 Universal Database Family -- 1.2.1 DB2 UDB for Linux, UNIX®, and Windows® -- 1.2.2 DB2 UDB for iSeries™ -- 1.2.3 DB2 Server for VSE and VM -- 1.2.4 More information on the DB2 UDB family, related tools, and products -- 1.3 Components of DB2 UDB for z/OS and OS/390 -- 1.3.1 DB2 UDB for z/OS and OS/390 address spaces -- 1.3.2 DB2 attachment facilities -- 1.4 DB2 data structures -- 1.4.1 Databases -- 1.4.2 Storage groups -- 1.4.3 Data sets -- 1.4.4 Table spaces -- 1.4.5 Tables -- 1.4.6 Indexes -- 1.5 Structured query language (SQL) -- 1.5.1 Static SQL -- 1.5.2 Dynamic SQL -- 1.5.3 Industry standards -- 1.6 DB2 concepts -- 1.6.1 Referential constraints -- 1.6.2 DB2 packages, plans, collections, and package lists -- 1.6.3 Schemas -- 1.7 Accessing DB2 from a Java environment -- 1.7.1 JDBC fundamentals -- 1.7.2 JDBC driver types -- 1.7.3 IBM DB2 Legacy Driver -- 1.8 IBM DB2 Universal Driver for SQLJ and JDBC -- 1.8.1 IBM z/OS Application Connectivity to DB2 for z/OS and OS/390 -- 1.9 Using the DB2 Universal Driver for SQLJ and JDBC -- 1.9.1 Required environment variable settings -- 1.9.2 DB2 Universal Driver stored procedures and metadata -- 1.9.3 Binding DB2 Universal JDBC Driver packages with the DB2Binder utility -- 1.9.4 DB2T4XAIndoubtUtil utility for DB2 UDB for OS/390 and z/OS Version 7 -- 1.9.5 Differences between the DB2 Universal Driver and DB2 Legacy Driver -- 1.9.6 JDBC 3.0 APIs specific to the DB2 Universal Driver -- Chapter 2. Introduction to WebSphere for z/OS -- 2.1 Java 2 Enterprise Edition (J2EE) overview.
2.2 WebSphere Application Server architecture -- 2.3 WebSphere Application Server administration -- 2.3.1 Administration console -- 2.3.2 Other tools -- 2.4 The WebSphere family -- 2.5 WAS 5.0.2 features and J2EE support -- Chapter 3. WebSphere - DB2 environment -- 3.1 Introduction to the sample scenario setup -- 3.2 Introduction to DB2 drivers for Java -- 3.3 Data source definitions in WAS V5 -- 3.4 The IBM DB2 Universal Driver for SQLJ and JDBC -- 3.4.1 Summary of WAS z/OS external changes for the Universal Driver -- 3.5 Configuring Universal JDBC Driver type 2 connectivity -- 3.5.1 Specifying the Universal JDBC Driver provider -- 3.5.2 Defining Data Sources under this provider -- 3.5.3 Setting/verifying the symbolic environment variables -- 3.5.4 Defining DB2 Universal Driver - General properties -- 3.5.5 Searching for the package to execute -- 3.5.6 Linking to the DB2 libraries -- 3.5.7 Creating a new Application Server -- 3.6 Configuring Universal JDBC Driver type 4 connectivity -- 3.6.1 Using the Universal Driver for type 4 (non-XA) -- 3.6.2 Using the Universal Driver for type 4 (XA) connectivity -- 3.7 Summary -- Chapter 4. DB2 and Java architecture guide -- 4.1 Introduction to J2EE data access architecture -- 4.2 Servlets and JavaServer Pages -- 4.2.1 Benefits of data access from servlets and JSPs -- 4.2.2 Considerations for data access from a servlet -- 4.3 Enterprise JavaBeans -- 4.4 Session Beans -- 4.5 Stateless session Beans -- 4.5.1 Benefits of data access from a stateless session Bean -- 4.5.2 Considerations -- 4.6 Stateful session Beans -- 4.6.1 Benefits of stateful session Beans -- 4.6.2 Considerations -- 4.7 Entity Beans -- 4.8 Bean-Managed Persistence entity Beans -- 4.8.1 Benefits -- 4.8.2 Considerations -- 4.9 Container-Managed Persistence entity Beans -- 4.9.1 Benefits -- 4.9.2 Considerations -- 4.10 Message-driven Beans. 4.11 Session facade pattern -- 4.12 Stored procedures -- 4.12.1 Benefits of accessing data from stored procedures -- 4.12.2 Considerations -- 4.13 Web services -- 4.14 SQLJ support -- 4.15 Java Data Objects -- 4.16 EJB Beans summary -- Chapter 5. DB2 application development in a WebSphere environment -- 5.1 JDBC and SQLJ application programming comparison -- 5.1.1 JDBC and SQLJ compared -- 5.1.2 Best practices -- 5.2 JDBC application programming concepts -- 5.2.1 Java packages for JDBC applications -- 5.2.2 Using the DB2 Universal JDBC Driver and the DataSource interface -- 5.2.3 Java identifiers and JDBC parameter markers -- 5.2.4 Statement and ResultSet interfaces -- 5.3 SQLJ application programming concepts -- 5.4 Preparing JDBC and SQLJ applications for execution -- 5.4.1 JDBC program preparation process -- 5.4.2 SQLJ program preparation process -- 5.5 Impact of different DB2 bind options on Java applications -- 5.5.1 OWNER bind option -- 5.5.2 QUALIFIER bind option -- 5.5.3 DYNAMICRULES bind option -- 5.5.4 ISOLATION bind option -- 5.6 Special registers -- 5.6.1 CURRENT SQLID -- 5.6.2 CURRENT SCHEMA -- 5.6.3 CURRENT PACKAGESET -- 5.6.4 CURRENT PACKAGE PATH -- 5.6.5 Using properties to specify special registers -- Chapter 6. WebSphere - DB2 security -- 6.1 Introduction to authentication, authorization, and auditing -- 6.1.1 Authentication -- 6.1.2 Authorization -- 6.1.3 Auditing -- 6.1.4 Application or infrastructure -- 6.1.5 DB2-supported authentication, authorization, and auditing -- 6.1.6 Choosing what identity to send DB2 -- 6.1.7 Configuring WebSphere for authentication -- 6.1.8 Programmatic authentication -- 6.1.9 Default user ID and password authentication -- 6.1.10 Thread identity support -- 6.2 DB2 auditing -- Chapter 7. SQLJ -- 7.1 Writing SQLJ versus JDBC applications -- 7.1.1 Connections -- 7.1.2 Using SQLJ -- 7.1.3 Using JDBC. 7.2 Profile customization -- 7.2.1 Profile customization when using unqualified SQL -- 7.2.2 Reducing the number of SQLJ-generated packages -- 7.2.3 Using manual package versioning -- 7.3 Application design -- 7.3.1 Best practice -- 7.3.2 The detailed application flow -- 7.3.3 Exceptions and transactions -- 7.3.4 SQL exceptions and SQL warnings -- 7.4 SQLJ in WebSphere Studio Application Developer -- 7.4.1 Setting up the environment -- 7.4.2 Create the server and the datasource -- 7.4.3 Using an SQLJ Java project -- 7.4.4 User-managed persistence -- 7.4.5 Container-managed persistence -- 7.4.6 Customization -- 7.4.7 WAS 5.1.0.1 FixPak -- 7.5 Deployment to WebSphere Application Server -- 7.6 Summary -- Chapter 8. Transaction management in a WebSphere environment -- 8.1 What transactions are -- 8.1.1 Local transactions -- 8.1.2 Global transactions -- 8.2 WebSphere transaction management -- 8.2.1 Transaction demarcation -- 8.2.2 Bean-managed transactions and the UserTransaction interface -- 8.2.3 Transaction types (for container-managed transactions) -- 8.3 WebSphere resources and transaction support -- 8.3.1 Resource interfaces -- 8.3.2 Resource transaction isolation -- 8.3.3 Configuring JDBC resources -- 8.4 DB2 as a transaction manager -- 8.4.1 Configuring and exploiting DB2 as a transaction manager -- 8.4.2 DB2 configuration requirements -- 8.4.3 DB2 or WAS as a transaction manager -- 8.5 DB2 as a resource manager -- 8.5.1 DB2's support for XA -- 8.5.2 Global transaction support -- 8.6 Considerations for two-phase commit processing -- 8.6.1 Lock duration -- 8.6.2 Failure impact -- 8.6.3 Lock impact from failure -- 8.6.4 How to recover from failures -- Chapter 9. DB2 locking in a WebSphere environment -- 9.1 DB2 locking -- 9.2 Transaction isolation -- 9.2.1 Isolation levels -- 9.2.2 Overriding lock mode. 9.2.3 DB2 isolation determination in Java applications -- 9.2.4 Maintaining integrity with isolation Cursor Stability -- 9.2.5 Data sharing considerations -- 9.3 WebSphere transaction-related deployment descriptors -- 9.3.1 Setting the WebSphere transaction isolation level -- 9.3.2 Entity Bean isolation level (access intent) -- 9.4 Container-managed persistence generated SQL -- 9.4.1 Who generates the persistence SQL -- 9.4.2 Access intents -- Chapter 10. DB2 - WebSphere performance aspects -- 10.1 Recommended hardware and software configuration -- 10.2 WebSphere Application Server connection pooling -- 10.2.1 What is new in Version 5 - What is in WebSphere Version 4 -- 10.2.2 How connection pooling works - How connection objects are structured -- 10.2.3 WebSphere data sources -- 10.2.4 Connection pooling - Best practices -- 10.3 DB2 and JDBC -- 10.3.1 Adjusting the number of DB2 threads and connections -- 10.3.2 Enabling DB2 dynamic statement cache -- 10.3.3 Choosing static SQL over dynamic SQL -- 10.3.4 Usage guidelines for JCC type 2 and type 4 connectivity -- 10.3.5 Enterprise JavaBeans (EJBs) and DB2 access -- 10.4 WLM classification of WAS and its impact on DB2 -- 10.4.1 How DB2 and WebSphere Servers are structured on z/OS -- 10.4.2 Enabling WLM dynamic application environments with WAS V5 -- 10.4.3 WebSphere classification and its impact on DB2 -- 10.5 Tuning the storage for z/OS and the Java Virtual Machine -- 10.6 Universal Driver tracing -- 10.6.1 Universal Driver tracing -- 10.6.2 DB2SystemMonitor class -- Chapter 11. Sample application -- 11.1 Introduction -- 11.1.1 Sample table description -- 11.1.2 Importing the tables into WSAD -- 11.2 MVC model with entity Beans and a session Bean -- 11.2.1 Creating entity CMP Beans using JDBC from the imported tables -- 11.2.2 Container-managed persistence entity Beans with SQLJ. 11.2.3 Bean and container-managed persistence entity Bean with SQLJ. |
| Altri titoli varianti |
Database 2 for z/OS and WebSphere
Database Two for z/OS and WebSphere |
| Record Nr. | UNINA-9910809602003321 |
| San Jose, : IBM, International Technical Support Organization, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB for z/OS version 8 [[electronic resource] ] : everything you ever wanted to know-- and more / / Bart Steegmans ... [et al.]
| DB2 UDB for z/OS version 8 [[electronic resource] ] : everything you ever wanted to know-- and more / / Bart Steegmans ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | White Plains, NY, : IBM, International Technical Support Organization, c2004 |
| Descrizione fisica | xxiv, 1066 p. : ill |
| Disciplina | 005.75/85 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910449880303321 |
| White Plains, NY, : IBM, International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB for z/OS version 8 [[electronic resource] ] : everything you ever wanted to know-- and more / / Bart Steegmans ... [et al.]
| DB2 UDB for z/OS version 8 [[electronic resource] ] : everything you ever wanted to know-- and more / / Bart Steegmans ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | White Plains, NY, : IBM, International Technical Support Organization, c2004 |
| Descrizione fisica | xxiv, 1066 p. : ill |
| Disciplina | 005.75/85 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783401003321 |
| White Plains, NY, : IBM, International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 UDB for z/OS version 8 : everything you ever wanted to know-- and more / / Bart Steegmans ... [et al.]
| DB2 UDB for z/OS version 8 : everything you ever wanted to know-- and more / / Bart Steegmans ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | White Plains, NY, : IBM, International Technical Support Organization, c2004 |
| Descrizione fisica | xxiv, 1066 p. : ill |
| Disciplina | 005.75/85 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Summary of changes -- July 2004 -- April 2005 -- Chapter 1. DB2 UDB for z/OS Version 8: At a glance -- 1.1 DB2 UDB for z/OS Version 8 - overview -- 1.2 Architecture -- 1.2.1 Unicode support -- 1.2.2 DB2 Connect and DRDA -- 1.2.3 Universal Driver for SQLJ and JDBC -- 1.2.4 Schema evolution -- 1.2.5 64-bit virtual storage -- 1.3 Usability, availability, and scalability -- 1.3.1 Partitioning -- 1.3.2 Create index dynamic statement invalidation -- 1.3.3 Minimize impact of creating deferred indexes -- 1.3.4 Column data type change -- 1.3.5 LOB ROWID transparency -- 1.3.6 Longer table and column names -- 1.3.7 SQL statements 2 MB long -- 1.3.8 Multiple DISTINCT clauses in SQL statements -- 1.3.9 More open data sets -- 1.3.10 More log data sets -- 1.3.11 CI size larger than 4 KB -- 1.4 Data warehouse -- 1.4.1 More tables in joins -- 1.4.2 Sparse index and in-memory workfiles for star join -- 1.4.3 Common table expression and recursive SQL -- 1.4.4 Materialized query tables -- 1.5 Performance -- 1.5.1 Locking improvements -- 1.5.2 Multi-row INSERT and FETCH -- 1.5.3 RUNSTATS improvements -- 1.5.4 Host variables impact on access paths -- 1.5.5 Index only access for VARCHAR -- 1.5.6 Backward index scan -- 1.5.7 Local SQL cache issues and short prepare -- 1.5.8 Multiple IN values -- 1.5.9 DDF performance -- 1.5.10 Automatic space management -- 1.5.11 Dynamic statement cache statement ID in EXPLAIN -- 1.5.12 Instrumentation enhancements -- 1.5.13 Migration changes -- 1.6 System level point-in-time backup and recovery -- Chapter 2. Scalability -- 2.1 Where are we today? (The problem) -- 2.2 DBM1 virtual storage constraint relief needed -- 2.3 DBM1 - Major VSTOR consumers -- 2.4 How to solve this problem?.
2.5 64-bit processor support -- 2.6 64-bit memory architecture (The solution) -- 2.7 Central storage on zSeries (z990/z900/z800/z890) -- 2.8 REAL storage support on zSeries - provided -- 2.9 REAL storage support on zSeries - migration -- 2.10 Large REAL memory support -- 2.11 DB2 (pre-V8) z/Architecture exploitation -- 2.12 Increasing processor speeds -- 2.13 Larger buffer pools -- 2.14 Hiperpools -- 2.15 BPs in data spaces - benefits -- 2.16 BPs in data spaces - problems -- 2.17 Other considerations -- 2.18 64-bit virtual address space memory map -- 2.19 DB2 V8 exploitation of 64-bit virtual storage -- 2.20 Why implement 64-bit VSTOR support? -- 2.21 What is moving above the 2 GB Bar? -- 2.22 DB2 benefits of 64-bit VSTOR support -- 2.23 64-bit virtual buffer pool support -- 2.23.1 Configuration changes -- 2.23.2 Migration sizing of buffer pools -- 2.23.3 Buffer pool sizing -- 2.23.4 Additional buffer pool information -- 2.23.5 New error messages -- 2.24 RIDPOOL - moving above the bar -- 2.25 Compression dictionaries - moving above the bar -- 2.26 Sort pool - moving above the bar -- 2.27 EDM pool - DBDs/OBDs/DSC - moving above the bar -- 2.27.1 Dynamic statement cache -- 2.27.2 Storing the DBDs -- 2.27.3 Storage for plans and packages -- 2.28 Other virtual storage related enhancements -- 2.28.1 LOB data -- 2.28.2 IPCS IRLM and DB2 dump formatting enhancements -- 2.28.3 Up to 65 000 open data sets -- 2.29 IRLM V2.2 64-bit IRLM for DB2 V8 -- 2.30 Immediate benefits -- 2.31 DB2 code considerations -- 2.32 Summarizing 64-bit changes in DB2 -- 2.33 Support for 4096 partitions -- 2.33.1 Requirements for 4096 partitions -- 2.33.2 Maximum number of partitions -- 2.33.3 Table space size and number of partitions -- 2.33.4 New data set naming convention -- 2.33.5 Database commands support enhancement -- 2.33.6 Display database command support. 2.33.7 Database command support - OVERVIEW keyword -- 2.33.8 Some considerations -- 2.34 More active log data sets -- 2.35 Increased maximum number of archive log data sets -- 2.36 Complex joins - up to 225 tables -- 2.36.1 Complex joins - up to 225 tables - 2 -- 2.36.2 Considerations for optimization thresholds -- 2.36.3 Affected interfaces -- 2.37 Longer SQL statements -- 2.37.1 Using 2 MB statements with dynamic SQL -- 2.37.2 Long SQL statement considerations -- 2.38 Long predicates -- 2.39 Long index keys -- Chapter 3. Availability -- 3.1 Availability - overview -- 3.2 Availability - 2 -- 3.3 Availability - 3 -- 3.4 Why partitioned table spaces -- 3.4.1 VLDB - DB2 objects keep getting bigger! -- 3.5 V7 Partitioned tables -- 3.5.1 Creating a partitioned table in Version 7 and prior -- 3.5.2 Creating the partitioning index -- 3.5.3 V7 Partitioned table space - index-controlled partitioning -- 3.5.4 Logical and physical partitions -- 3.5.5 Challenges when using NPIs prior to DB2 V8 -- 3.5.6 V7 and prior - contention on the NPI -- 3.6 V8 Partitioned tables -- 3.6.1 V8 partitioned tables, table-controlled partitioning -- 3.6.2 V8 - Creating partitioned tables -- 3.6.3 Converting to table-controlled partitioning -- 3.6.4 Catalog support for table-controlled partitioning -- 3.7 DB2 V8 classification of indexes -- 3.7.1 Index classification -- 3.7.2 Partitioning indexes -- 3.7.3 Secondary indexes -- 3.7.4 Partitioned and non-partitioned indexes -- 3.7.5 Partitioned and non-partitioned partitioning indexes -- 3.7.6 Partitioned and non-partitioned secondary indexes -- 3.8 Data-partitioned secondary indexes -- 3.8.1 Creating a data-partitioned secondary index -- 3.8.2 DPSIs and utility operations -- 3.8.3 Data sharing overhead reduction -- 3.8.4 DPSI query performance -- 3.8.5 Design considerations - initial thoughts -- 3.8.6 Utility operations - DPSIs. 3.8.7 System planning and administration of DPSIs -- 3.9 Displaying indexes in DB V8 -- 3.9.1 Displaying a partitioned partitioning index -- 3.9.2 Displaying non-partitioned indexes -- 3.9.3 Displaying data-partitioned secondary indexes -- 3.10 Clustering indexes -- 3.10.1 A clustering index can be a secondary index -- 3.10.2 Clustering NPSI -- 3.10.3 Clustering DPSI -- 3.11 Online schema changes -- 3.11.1 The availability story -- 3.11.2 Performing schema changes today (V7) -- 3.11.3 What is new in V8 -- 3.11.4 Key benefits -- 3.11.5 Altering tables -- 3.11.6 Altering column data types -- 3.11.7 Supported alter data types -- 3.11.8 Alter data type syntax -- 3.11.9 What happens to the table? -- 3.11.10 What happens to the data? -- 3.11.11 What happens to dependent indexes? -- 3.11.12 How about referencing views and check constraints? -- 3.11.13 Considerations when changing data types -- 3.11.14 Restrictions -- 3.11.15 Operational impact -- 3.11.16 Altering index attributes -- 3.11.17 Altering index add column syntax -- 3.11.18 Alter index add column -- 3.11.19 Restrictions -- 3.11.20 RBDP considerations -- 3.12 Versioning -- 3.12.1 Catalog support for versioning -- 3.12.2 Minimize the number of active versions -- 3.12.3 Reclaiming versions -- 3.12.4 Segmented table space example -- 3.12.5 A word on system pages -- 3.13 Partition management -- 3.13.1 Adding a partition to a partitioned table space - current situation -- 3.13.2 ALTER TABLE ADD PARTITION syntax -- 3.13.3 Add a partition to a partitioned table space -- 3.13.4 Adding a partition - considerations -- 3.13.5 Rotate partition - overview -- 3.13.6 Alter table rotate partition syntax -- 3.13.7 Rotate partition example -- 3.13.8 Rotate partition effect -- 3.13.9 Considerations when rotating partitions -- 3.13.10 Display command output -- 3.13.11 Alter partition boundary. 3.13.12 Alter partition boundary example -- 3.13.13 Rebalance partitions -- 3.14 Other index enhancements -- 3.14.1 Altering index padding attribute -- 3.14.2 Alter index not padded/padded -- 3.14.3 Alter the clustering attribute of indexes -- 3.14.4 RBDP Index avoidance -- 3.14.5 Index creation enhancements -- 3.15 Reviewing DBET states used by online schema evolution -- 3.15.1 Review of new DBET states -- 3.16 System level point-in-time recovery -- 3.16.1 Prerequisites for this feature -- 3.16.2 BACKUP SYSTEM -- 3.16.3 BACKUP SYSTEM operation -- 3.16.4 RESTORE SYSTEM operation -- 3.17 More online ZPARMs -- 3.18 Other availability enhancements -- 3.18.1 Control interval larger than 4KB -- 3.18.2 Monitoring system checkpoints and log offload activity -- 3.18.3 Log Monitoring long running UR backout -- 3.18.4 Detecting long readers -- 3.18.5 Lock holder can inherit WLM priority from lock waiter -- 3.18.6 Lock escalation IFCID -- 3.18.7 Partitioning key update enhancements -- 3.18.8 Improved LPL recovery -- 3.18.9 SMART DB2 extent sizes for DB2 managed objects -- 3.18.10 Logging manageability enhancements -- Chapter 4. SQL enhancements -- 4.1 Breaking SQL limitations -- 4.2 Static scrollable cursors - V7 review -- 4.2.1 Sensitive and insensitive cursors - V7 review -- 4.3 Dynamic scrollable cursors - V8 new function -- 4.3.1 DECLARE CURSOR syntax -- 4.3.2 Declare cursor - new attributes -- 4.3.3 FETCH syntax using dynamic scrollable cursors -- 4.3.4 Implications on FETCH -- 4.3.5 Locking with dynamic scrollable cursors -- 4.3.6 UPDATE using dynamic scrollable cursors -- 4.3.7 Dynamic scrollable cursors considerations -- 4.3.8 DRDA considerations -- 4.3.9 Dynamic scrollable cursor example - 1 -- 4.3.10 Dynamic scrollable cursor example - 2 -- 4.3.11 Cursor type comparison -- 4.4 Multi-row FETCH and INSERT -- 4.5 Multi-row FETCH. 4.5.1 DECLARE CURSOR syntax. |
| Record Nr. | UNINA-9910819163303321 |
| White Plains, NY, : IBM, International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
XML for DB2 information integration [[electronic resource] /] / [Bart Steegmans ... et al.]
| XML for DB2 information integration [[electronic resource] /] / [Bart Steegmans ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | White Plains, NY, : IBM, International Technical Support Organization, c2004 |
| Descrizione fisica | xxxiv, 672 p. : ill |
| Disciplina | 006.7/4 |
| Altri autori (Persone) | SteegmansBart |
| Collana | IBM redbooks |
| Soggetto topico |
XML (Document markup language)
Database management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450158103321 |
| White Plains, NY, : IBM, International Technical Support Organization, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
