ORPP logo

Siebel 7 with DB2 for z/OS : (Record no. 76490)

MARC details
000 -LEADER
fixed length control field 07107nam a22004813i 4500
001 - CONTROL NUMBER
control field EBC3306729
003 - CONTROL NUMBER IDENTIFIER
control field MiAaPQ
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20240729124922.0
006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS
fixed length control field m o d |
007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION
fixed length control field cr cnu||||||||
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 240724s2003 xx o ||||0 eng d
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9780738428062
Qualifying information (electronic bk.)
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
Canceled/invalid ISBN 9780738428062
035 ## - SYSTEM CONTROL NUMBER
System control number (MiAaPQ)EBC3306729
035 ## - SYSTEM CONTROL NUMBER
System control number (Au-PeEL)EBL3306729
035 ## - SYSTEM CONTROL NUMBER
System control number (CaPaEBR)ebr10112825
035 ## - SYSTEM CONTROL NUMBER
System control number (OCoLC)842967418
040 ## - CATALOGING SOURCE
Original cataloging agency MiAaPQ
Language of cataloging eng
Description conventions rda
-- pn
Transcribing agency MiAaPQ
Modifying agency MiAaPQ
050 #4 - LIBRARY OF CONGRESS CALL NUMBER
Classification number QA76.9.D3 -- S562855 2003eb
082 0# - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.74
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Redbooks, IBM.
245 10 - TITLE STATEMENT
Title Siebel 7 with DB2 for z/OS :
Remainder of title Database Implementation and Administration Guide.
250 ## - EDITION STATEMENT
Edition statement 1st ed.
264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE
Place of production, publication, distribution, manufacture Durham :
Name of producer, publisher, distributor, manufacturer I B M,
Date of production, publication, distribution, manufacture, or copyright notice 2003.
264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE
Date of production, publication, distribution, manufacture, or copyright notice ©2003.
300 ## - PHYSICAL DESCRIPTION
Extent 1 online resource (238 pages)
336 ## - CONTENT TYPE
Content type term text
Content type code txt
Source rdacontent
337 ## - MEDIA TYPE
Media type term computer
Media type code c
Source rdamedia
338 ## - CARRIER TYPE
Carrier type term online resource
Carrier type code cr
Source rdacarrier
505 0# - FORMATTED CONTENTS NOTE
Formatted contents note Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Overview of Siebel 7 with DB2 for z/OS database -- 1.1 Siebel 7 system architecture overview -- 1.2 Siebel 7 database implementation overview -- 1.3 Siebel 7 database administration overview -- 1.4 DB2 for z/OS V7 functions that benefit Siebel 7 -- 1.4.1 Correlated subquery for UPDATE joins -- 1.4.2 Self-referencing subselect with UPDATE/DELETE -- 1.4.3 Online system parameters -- 1.4.4 Scrollable cursors -- 1.4.5 MEMBER ID for sysplex scalability -- 1.4.6 Realtime statistics -- 1.4.7 FETCH FIRST n ROWS -- 1.4.8 Asynchronous preformatting -- 1.4.9 Catalog row-level locking -- 1.4.10 REORG enhancements -- 1.4.11 Statistics HISTORY -- 1.4.12 New monitoring indicators -- 1.5 DB2 Connect EE V7 database connectivity -- 1.5.1 DB2 database connection types -- 1.5.2 DB2 Connect EE setup overview -- 1.6 Siebel 7 database connection pooling -- Chapter 2. Installing the Siebel 7 system environment -- 2.1 System configuration -- 2.1.1 Siebel 7 client tier -- 2.1.2 Siebel 7 mid-tier -- 2.1.3 Siebel 7 database tier -- 2.2 z/OS security setup -- 2.2.1 RACF - userids and groups -- 2.2.2 DB2 UDB for z/OS and OS/390 authorization -- 2.3 DB2 for OS/390 and z/OS setup -- 2.3.1 DSNZPARM values -- 2.3.2 Buffer pools and storage group -- 2.3.3 DB2 objects for Siebel -- 2.3.4 Stored procedures -- 2.4 Mid-tier setup -- 2.4.1 AIX V5L configuration -- 2.4.2 SAMBA install and setup -- 2.4.3 HTTP Web server install and setup -- 2.4.4 DB2 Connect EE V7.2 installation -- 2.4.5 DB2 Connect Fix Pack 5s installation -- 2.4.6 DB2 Connect configuration -- 2.5 Installation of Siebel 7 servers -- 2.5.1 Installation of Siebel 7 Gateway server -- 2.5.2 Installation of Siebel 7 Application server.
505 8# - FORMATTED CONTENTS NOTE
Formatted contents note 2.5.3 Installation of Siebel 7 database scripts -- 2.5.4 Installation of Siebel 7 maintenance - 7.0.4.200 -- 2.5.5 Installation of Siebel 7 database schema -- 2.5.6 Post-installation tasks -- 2.6 Installation of Siebel 7 Web server and extensions -- 2.6.1 Customizing the Siebel 7 Web server -- 2.7 Installation of Siebel 7 Web server maintenance - 7.0.4.200 -- Chapter 3. Modifying the Siebel schema for a production environment -- 3.1 Extracting a current storage control file -- 3.2 Modifying the storage control file - table space partitioning -- 3.2.1 Running the Siebel Database Configuration utility -- 3.2.2 Creating a backup table -- 3.2.3 Synchronize schema definition - produce a new schema file -- 3.2.4 Applying the schema changes -- 3.2.5 Saving the storage control file -- Chapter 4. Migration from development to the production system -- 4.1 Running dev2prod -- 4.2 Reviewing the schema file - applying the DDL to the production system -- 4.3 Activating the repository imported from development -- Chapter 5. Identifying and removing unused, non-unique indexes -- 5.1 Why remove indexes -- 5.2 Which indexes to remove -- 5.3 Siebel functional areas of interest -- 5.4 Identifying unused, non-unique indexes -- 5.4.1 In the EIM load process -- 5.4.2 In Siebel online -- 5.4.3 Index identification procedure -- 5.5 Inactivation of unused indexes -- Chapter 6. Partitioning method using DB2 utilities -- 6.1 Planning steps for partitioning Siebel tables -- 6.2 Identifying candidate tables and partition columns -- 6.3 Planning for REXX procedures -- 6.4 Unloading the tables -- 6.4.1 Reference table -- 6.4.2 Unloading the data -- 6.5 Creating new tables with partitions -- 6.6 Loading the tables -- 6.7 Reorganizing the tables -- Chapter 7. Monitoring dynamic SQL -- 7.1 Monitoring dynamic SQL in the DSC -- 7.1.1 DB2 PM Workstation Online Monitor tool.
505 8# - FORMATTED CONTENTS NOTE
Formatted contents note 7.1.2 Explaining SQL statement from the cache -- 7.1.3 Identifying inefficient SQL -- 7.1.4 Considerations on parameter markers -- 7.2 Siebel SQL tracing -- 7.2.1 Object Manager -- 7.2.2 Dedicated Web client -- 7.2.3 EIM performance considerations -- Chapter 8. Monitoring the Siebel 7 database -- 8.1 DB2 installation considerations -- 8.1.1 Database objects -- 8.1.2 Free space -- 8.1.3 EDM pool size -- 8.1.4 Buffer pools -- 8.2 DB2 statistics -- 8.2.1 Why collect statistics -- 8.2.2 What statistics should you gather for Siebel -- 8.2.3 Monitoring VSAM data set extents -- 8.3 DB2 history statistics -- 8.3.1 Monitoring space growth -- 8.3.2 Monitoring the rebuild of the compression dictionary -- 8.4 DB2 realtime statistics -- 8.5 Database reorganization -- 8.6 Siebel-DB2 database recovery -- 8.6.1 Recovery to currency -- 8.6.2 Disaster recovery -- 8.6.3 Point-in-time recovery -- Appendix A. DB2 parameters -- A.1 DSNZPARM values used for the Siebel 7 installation -- Appendix B. Sample Siebel 7 generate DDL output -- B.1 Sample generate DLL output -- Appendix C. Batch jobs for table space partitioning -- C.1 Batch job used to create a backup table space -- C.2 Batch job used to create a partitioned table space -- Appendix D. REXX procedures for table space partitioning -- D.1 Reference table -- D.2 Unload jobs and procedures -- D.3 Load jobs and procedures -- Appendix E. REXX program for EXPLAIN -- Appendix F. Additional material -- Locating the Web material -- Using the Web material -- How to use the Web material -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover.
588 ## - SOURCE OF DESCRIPTION NOTE
Source of description note Description based on publisher supplied metadata and other sources.
590 ## - LOCAL NOTE (RLIN)
Local note Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element IBM Database 2.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element z/OS.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Database management.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Application software.
655 #4 - INDEX TERM--GENRE/FORM
Genre/form data or focus term Electronic books.
776 08 - ADDITIONAL PHYSICAL FORM ENTRY
Relationship information Print version:
Main entry heading Redbooks, IBM
Title Siebel 7 with DB2 for z/OS
Place, publisher, and date of publication Durham : I B M,c2003
International Standard Book Number 9780738428062
797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN)
Corporate name or jurisdiction name as entry element ProQuest (Firm)
856 40 - ELECTRONIC LOCATION AND ACCESS
Uniform Resource Identifier <a href="https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3306729">https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3306729</a>
Public note Click to View

No items available.

© 2024 Resource Centre. All rights reserved.