1.

Record Nr.

UNINA9910822041103321

Autore

Saraswatipura Mohankumar

Titolo

DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins

Pubbl/distr/stampa

Boise, ID : , : MC Press Online, LLC, , [2015]

©2015

ISBN

1-58347-716-0

Edizione

[First edition.]

Descrizione fisica

1 online resource (1248 p.)

Disciplina

005.7565

Soggetti

Database management - Examinations

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Description based upon print version of record.

Nota di contenuto

Front Cover; Title Page; Copyright; About the Authors; Acknowledgments; Contents; Foreword; 1: IBM DB2 10.1 Certification; DB2 10.1 Certification Roles; DB2 10.1 Certification Tracks; The Certification Process; Taking an IBM Certification Exam; 2: DB2 Server Management; Exam Objectives; Working with Instances; Configuring the DB2 System Environment; Configuring DB2 Instances and Databases; DB2 Autonomic Computing Features; Automatic Storage; Data Compression; Automatic Database Maintenance; The Configuration Advisor; Adaptive Utility Throttling; Taking Control of a DB2 Server

Working with IBM Data StudioConnecting to Instances and Databases; Generating Data Definition Language Scripts; Performing Database Administration Tasks; Performing Database Development Tasks; Scheduling Database Jobs; Analyzing SQL Queries; Chapter Summary; Practice Questions; Answers; 3: Physical Design; Exam Objectives; Servers, Instances, and Databases; DB2 Database Objects; Creating a DB2 Database; A Complete CREATE DATABASE Command; Design Aspects of Databases; Buffer Pools; Table Spaces; Reclaimable Storage; Storage Groups; Schemas; Range Clustering and Range Partitioning Tables

Range Clustered TablesRange Partitioned Tables; Multi-temperature Storage; Time Travel Query Using Temporal Tables; Utilities, Tools, and



File Type Modifiers; Restrictions for System-Period Temporal Tables; Application-Period Temporal Tables; Bitemporal Period Tables; Working with XML Data; Data Compression; DB2 9.7-Increasing the Compression Landscape; Chapter Summary; Practice Questions; Answers; 4: Business Rules Implementation; Exam Objectives; Business Rules; Not Null Constraints; Default Constraints; Check Constraints; Unique Constraints; Referential Integrity Constraints

Informational ConstraintsThe Set Integrity Command; Creating Tables and Constraints; Creating Views with the Check Option; Creating and Using Triggers; Chapter Summary; Practice Questions; Answers; 5: Monitoring DB2 Activity; Exam Objectives; The Database System Monitor; The Snapshot Monitor; Table Functions for Monitoring; Functions Quick Reference; Administrative Views for Monitoring; Buffer Pool Hit Ratio and I/O Response Time; Currently Running Expensive SQL Statement; Current Lock-wait Chains in the Database; Understanding Your Table Spaces; Getting to Know Your Database Server

Event MonitorsEvent Types and Examples; Reading Unformatted Event Data; Unformatted Event Data Format Table Functions; Analyzing SQL with the Explain Facility; The Explain Tables; Collecting Explain Data; Evaluating Explain Data; DB2 Troubleshooting Tools; Obtaining Information About an Error Code; Reason Codes; The db2diag Utility; First Occurrence Data Capture (FODC); The DB2 Diagnostic Log File; The Administration Notification Log; Controlling How Much Information Is Collected; Interpreting the Notification and Diagnostic Log Entries; The db2pdcfg Command; The db2bfd Command

The db2val Command



2.

Record Nr.

UNINA9910963566803321

Autore

Nuyts Jan

Titolo

Aspects of a cognitive-pragmatic theory of language : on cognition, functionalism, and grammar / / Jan Nuyts

Pubbl/distr/stampa

Amsterdam ; ; Philadelphia, : J. Benjamins, 1992

ISBN

90-272-8595-0

1-283-09276-X

9786613092762

Edizione

[1st ed.]

Descrizione fisica

1 online resource (417 p.)

Collana

Pragmatics & Beyond New Series ; ; 20

Pragmatics & beyond, , 0922-842X ; ; new ser., 20

Classificazione

ER 720

Disciplina

401/.9

Soggetti

Psycholinguistics

Cognition

Functionalism (Linguistics)

Generative grammar

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Description based upon print version of record.

Nota di bibliografia

Includes bibliographical references and indexes.

Nota di contenuto

ASPECTS OF A COGNITIVE-PRAGMATIC THEORY OF LANGUAGE; Editorial page; Title page; Copyright page; Preface; Table of contents; Introduction; 1. Elements of the Theory; 2. Linguistic Knowledge and Language Use: Chomsky Revisited; 3. Linguistic and Conceptual Systems in Language Processing; Conclusion; References; Subject Index; Index of Names; The series Pragmatics & Beyond New Series

Sommario/riassunto

This book is about a theory of language that combines two observations (1) that language is based on an extensive cognitive infrastructure (cognitivism) and (2) that it is functional for its user (functionalism). These observations are regarded as two dimensions of one phenomenon that both need to be accounted for, simultaneously and coherently, in accounting for language. Chapter 1 presents the cognitivist and functionalist points of view and their interrelation and discusses the integration of language research under a cognitive umbrella; the issue of defining 'functions of language', and th