FRINK Linked Data Fragments server

Matches in SemOpenAlex for { <https://semopenalex.org/work/W599555770> ?p ?o ?g. }

• W599555770 abstract "From the Book:PREFACE: PREFACEDB2 is IBM's premiere relational database product for MVS. Since DB's inception, several books have been published - many of themintroductory texts that present DB2 fundamentals to professionalsgetting started with the product. This book is intended to pick upwhere introductory texts leave off. Because this is not an introductory text,it is assumed that the reader has a degree of familiarity with DB2. This book is aimed at the database administrator (DBA), or the application developer interested in DBA subjects who has minimally completed an introductory course in DB2 or has an equivalent working knowledge of the product. Terms such as buffer pool and tablespace should not be foreign to the reader.The book poses specific and complex problems not covered eitherin introductory texts or directly in the DB2 manuals. The materialis presented from a problem solving point of view and brings together relevant information from DB2 manuals, courses, conferences, and seminars in a way that is immediately useful tothe DBA. The book has been researched and presented from the perspective of the practitioner. It explores scenarios andproblem situations the DB2 DBA will almost always encounter.For most companies the DBA is the end of the line. If he or she cannot solve the problem, who can? Not surprisingly, there is atremendous demand for experienced DBAs who have dealt with the challenges that were not covered in courses or textbooks. It is the author's aim that this book will help provide the experiencethe DBA needs to meet the demands of the job. The book covers newfeatures of the version 2.3. The discussion concentrates on the costsandbenefits of using the new features and gives specific examples of how the features may be put to use.The book covers version 2.2 and version 2.3. Additional text has been added to topics affected by version 2.3 new features.The book is structured as 42 topics grouped into five parts. For the most part, the topics can be read independently withoutany loss of continuity. If your installation has installed DB2 and already has established naming conventions, then you may wantto skip the first two topics.The first part explores many of these issues the DBA will address when setting up a DB2 environment. Subsystem architecture,migration, decision support refresh, and QMF are some of the subjects covered in this set of topics.The second part consists of database design topics. Rather thantheory, instead it presents specific physical design issues,trade-offs, and alternatives the DBA will face in the design of alarge database. Hot spots, sparse indexes, surrogate keys, and data integrity checks are some of the topics in this part.In part three, the reader is quizzed on SQL. It is essentialthat the DBA master SQL because, after all, he or she will develop the SQL coding standards, assist in improving the performance of problem SQL statements. In this part, several handy queries are presented that will assist in managing the DB2environment. How to find duplicate rows, the outer join problem,and the power of the existential quantifier are some of thetopics covered.Part four is a compendium of short tips on DB2 performance. These topics have been selected from seminars, specialty books, and practical experience. CICS RCT design, variable free space,and denormalization versus DB2 joins are some of the subjects inthis series of topics.Part five deals mostly with backup and recovery situations youhope to avoid. Every DBA should be able to navigate through theserelevant problems not previously covered in DB2 manuals or intro-ductory texts. You are encouraged to get some hands-onexperience-try dropping a tablespace or a table and restore it using DSN1COPY and an image copy. Or, drop a view and try using DSN1LOGP to find your unit of recovery and login ID.Appendix A is a treasure chest of handy tools used in day-to-day operations. These include simple CLIST or edit macros you canwrite in minutes. For example, one of the tools is a simple Rexxroutine that will convert hexadecimal numbers to decimal and viceversa.Appendixes B and C show how to convert hexadecimal numbers to decimal and how to do two's complement arithmetic.Appendix D may be used as a quick reference for internal DB2page formats. Appendix E surveys third-party tools for DB2. For each categoryof tool, a list of vendors is given. This list is not exhaustivebut represents a list of the most popular vendors. Although someof the examples in the book make reference to specific thirdparty tools, such references do not constitute an endorsement. Readersare encouraged to evaluate competing products based on their ownrequirements and to make independent judgements.This book covers a lot of ground. It is concise and to the point. It is successful if after it is read, it is placed nearthe DB2 manuals and is referred to in times of need. It is most successful if it motivates the reader to simulate and solve someof the problem scenarios.ACKNOWLEDGMENTSI would like to thank the following people for reviewing thebook:Marilyn BohlJoe CarolaWilliam FaveroBrian HolroydMartin HubelHelen McMillanRoger L. MillerTim QuinlanAnd more importantly, I thank all the DB2 DBAs at Revenue Canada who have worked under Armin T. Kastner on the GST project. Muchof the inspiration for this book has come from this talentedgroup of professionals and I hope they share my sense of satisfaction.020157652XP04062001" @default.
• W599555770 created "2016-06-24" @default.
• W599555770 creator A5044247808 @default.
• W599555770 date "1993-04-01" @default.
• W599555770 modified "2023-09-27" @default.
• W599555770 title "Advanced Topics in DB2" @default.
• W599555770 hasPublicationYear "1993" @default.
• W599555770 type Work @default.
• W599555770 sameAs 599555770 @default.
• W599555770 citedByCount "0" @default.
• W599555770 crossrefType "book" @default.
• W599555770 hasAuthorship W599555770A5044247808 @default.
• W599555770 hasConcept C12713177 @default.
• W599555770 hasConcept C136764020 @default.
• W599555770 hasConcept C154945302 @default.
• W599555770 hasConcept C171250308 @default.
• W599555770 hasConcept C192562407 @default.
• W599555770 hasConcept C199360897 @default.
• W599555770 hasConcept C2524010 @default.
• W599555770 hasConcept C2779955035 @default.
• W599555770 hasConcept C28719098 @default.
• W599555770 hasConcept C33923547 @default.
• W599555770 hasConcept C41008148 @default.
• W599555770 hasConcept C70236469 @default.
• W599555770 hasConcept C70388272 @default.
• W599555770 hasConcept C77088390 @default.
• W599555770 hasConcept C90673727 @default.
• W599555770 hasConceptScore W599555770C12713177 @default.
• W599555770 hasConceptScore W599555770C136764020 @default.
• W599555770 hasConceptScore W599555770C154945302 @default.
• W599555770 hasConceptScore W599555770C171250308 @default.
• W599555770 hasConceptScore W599555770C192562407 @default.
• W599555770 hasConceptScore W599555770C199360897 @default.
• W599555770 hasConceptScore W599555770C2524010 @default.
• W599555770 hasConceptScore W599555770C2779955035 @default.
• W599555770 hasConceptScore W599555770C28719098 @default.
• W599555770 hasConceptScore W599555770C33923547 @default.
• W599555770 hasConceptScore W599555770C41008148 @default.
• W599555770 hasConceptScore W599555770C70236469 @default.
• W599555770 hasConceptScore W599555770C70388272 @default.
• W599555770 hasConceptScore W599555770C77088390 @default.
• W599555770 hasConceptScore W599555770C90673727 @default.
• W599555770 hasLocation W5995557701 @default.
• W599555770 hasOpenAccess W599555770 @default.
• W599555770 hasPrimaryLocation W5995557701 @default.
• W599555770 hasRelatedWork W151748074 @default.
• W599555770 hasRelatedWork W1524646841 @default.
• W599555770 hasRelatedWork W1590622018 @default.
• W599555770 hasRelatedWork W1600495937 @default.
• W599555770 hasRelatedWork W2032317547 @default.
• W599555770 hasRelatedWork W2041814227 @default.
• W599555770 hasRelatedWork W2162320715 @default.
• W599555770 hasRelatedWork W2182399898 @default.
• W599555770 hasRelatedWork W2329079356 @default.
• W599555770 hasRelatedWork W2343258973 @default.
• W599555770 hasRelatedWork W2345221714 @default.
• W599555770 hasRelatedWork W2474202725 @default.
• W599555770 hasRelatedWork W2503442638 @default.
• W599555770 hasRelatedWork W2562847368 @default.
• W599555770 hasRelatedWork W3020816429 @default.
• W599555770 hasRelatedWork W307335950 @default.
• W599555770 hasRelatedWork W3169053993 @default.
• W599555770 hasRelatedWork W345421675 @default.
• W599555770 hasRelatedWork W51526084 @default.
• W599555770 hasRelatedWork W855344965 @default.
• W599555770 isParatext "false" @default.
• W599555770 isRetracted "false" @default.
• W599555770 magId "599555770" @default.
• W599555770 workType "book" @default.