Data Movement Utilities Guide and Reference

Index

A B C D E F G H I K L M N O P Q R S T U V W

Administering Satellites Guide and Reference (895)

Administration Guide (875)

Administrative API Reference (876)

anyorder (667)

APPC, CPI-C and SNA Sense Codes (878)

Application Building Guide (877)

Application Development Guide (879)

application record, PC/IXF (818)

ASC data type descriptions (794)

ASC file

format (790)

sample (793)

ASC, as an import file type (598)

authorities

required for AutoLoader utility (732)

required for export utility (554)

required for import utility (584)

required for load utility (650)

AutoLoader utility

authorities and privileges required to use (734)

limitations (736)

overview of (725)

restrictions (735)

troubleshooting (737)

binarynumerics (680)

buffered inserts

import utility (590)

character string delimiter (784)

chardel (569), (618), (687)

CLI Guide and Reference (880)

code page considerations

import utility (631)

load utility (710)

code page conversion

files (838)

when importing or loading PC/IXF data (839)

codepage (676)

coldel (570), (619), (688)

column

specifying for import (600)

column descriptor record, PC/IXF (812)

column values, invalid (836)

columns, incompatible (834)

Command Reference (881)

command syntax

interpreting (771)

completion messages (866)

compound (606)

Connectivity Supplement (885)

constraints checking (653)

Data Movement Utilities Guide and Reference (882)

data record, PC/IXF (815)

data transfer

across platforms (747)

AutoLoader utility (726)

between host and workstation (753)

data type descriptions

ASC (795)

DEL (787)

PC/IXF (828)

data types

PC/IXF (822)

Database Movement Tool (751)

datesiso (571), (620), (689)

DB2 Connect Enterprise Edition for OS/2 and Windows NT Quick Beginnings (902)

DB2 Connect Enterprise Edition for UNIX Quick Beginnings (903)

DB2 Connect Personal Edition Quick Beginnings (883)

DB2 Connect User's Guide (884)

DB2 Data Links Manager

export utility (738)

exporting between instances (740)

import utility (741)

load utility (743)

troubleshooting the load utility (745)

DB2 Data Links Manager for AIX Quick Beginnings (904)

DB2 Data Links Manager for Windows NT Quick Beginnings (905)

DB2 Enterprise - Extended Edition for UNIX Quick Beginnings (900)

DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings (901)

DB2 library

books (874)

Information Center (912)

language identifier for books (909)

late-breaking information (910)

online help (873)

ordering printed books (917)

printing PostScript books (916)

searching online information (915)

setting up document server (913)

SmartGuides (872)

structure of (871)

viewing online information (911)

DB2 Personal Edition Quick Beginnings (896)

DB2 Query Patroller Administration Guide (906)

DB2 Query Patroller Installation Guide (907)

DB2 Query Patroller User's Guide (908)

db2LoadQuery - Load Query (663)

DB2LOADREC (655)

db2move (752)

decplusblank (572), (621), (690)

decpt (573), (622), (691)

DEL data type descriptions (786)

DEL file

format (780)

sample (783)

delimited ASCII (DEL) file format (778)

moving data across platforms (749)

delimiter

character string (785)

delprioritychar (623), (692)

differences between PC/IXF and System/370 IXF (857)

dldel (574), (624), (693)

dump file

load utility (700)

dumpfile (677)

environment variables

DB2LOADREC (656)

error messages (865)

example

forcein (851)

exception table

load utility (698)

export message files (578), (639), (722)

export utility

authorities and privileges required to use (556)

DB2 Data Links Manager (739)

large objects (LOBS) (559)

overview of (553)

recreating an exported table (557)

restrictions (576)

transferring data between host and workstation (754)

export utility file formats (775)

exporting

file type modifiers for (565)

specifying column names (563)

fastparse (668)

file format

delimited ASCII (DEL) (779)

non-delimited ASCII (ASC) (789)

PC version of IXF (PC/IXF) (797)

worksheet (WSF)) (862)

file formats

for exporting table to file (561)

for importing file to table (599)

file type modifiers

export utility (566)

import utility (604)

load utility (665)

forcein (626), (695)

code page semantics (848)

data type semantics (852)

example (850)

general semantics (846)

option (844)

summary of PC/IXF file import with (854)

Glossary (886)

hashing algorithm (731)

header record, PC/IXF (806)

IBM Relational Data Replication Tools

components (766)

overview (765)

implieddecimal (611), (678)

import

of PC/IXF files, with forcein (856)

import message files (579), (640), (723)

import of PC/IXF files

data type-specific rules (843)

general rules (831)

import utility

authorities and privileges required to use (586)

buffered inserts (589)

client/server (587)

code page considerations (630)

compared to load utility (772)

DB2 Data Links Manager (742)

large objects (LOBS) (593)

limitations (636)

optimizing performance (632)

overview of (581)

performance (633)

recreating an exported table (591)

remote database (588)

restrictions (635)

transferring data between host and workstation (755)

user-defined distinct types (UDTs) (595)

import utility file formats (776)

importing

file type modifiers for (603)

PC/IXF file to table (597)

incompatible columns (833)

indexfreespace (669)

indexixf (627)

indexschema (628)

indicator

record length (803)

Installation and Configuration Supplement (887)

Integration Exchange Format (IXF) (799)

invalid PC/IXF column values (835)

invalid PC/IXF data type (824)

keywords

syntax for (769)

large objects (LOBS)

export utility (560)

import utility (594)

LOAD

temporary files (658)

load delete start compensation log record (707)

load message files (580), (641), (724)

load pending list log record (708)

LOAD QUERY (659)

LOAD QUERY (db2LoadQuery) (662)

load start log record (705)

load utility

authorities and privileges required to use (652)

build phase (645)

code page considerations (709)

compared to import utility (773)

database recovery (647)

DB2 Data Links Manager (744)

delete phase (646)

dump file (699)

exception table (697)

limitations (719)

load phase (644)

log records (703)

optimizing performance (716)

overview of (642)

parallelism (649)

process overview (643)

recovery from failure (654)

restrictions (718)

running concurrent jobs (720)

temporary files (701)

load utility file formats (777)

file type modifiers for (664)

loading data

AutoLoader utility for loading data on database partitions (728)

lobsinfile (568), (607), (670)

log records

load utility (704)

message files: export, import, and load (577), (638), (721)

Message Reference (888)

messages (867)

modifiers, file type

for export utility (567)

for import utility (605)

for load utility (666)

moving data

across platforms (746)

nochecklengths (613), (629), (681), (696)

nodefaults (609)

nodoubledel (575), (625), (694)

noeofchar (612), (679)

noheader (671)

non-delimited ASCII (ASC) file format (788)

norowwarnings (672)

no_type_id (608)

nullindchar (614), (682)

option

forcein (845)

packeddecimal (683)

pagefreespace (673)

parallelism

load utility (648)

parameters

syntax for (768)

partitioning data

AutoLoader utility (727)

partitioning keys (729)

PC version of IXF (PC/IXF) file format (796)

PC/IXF

code page conversion files (840)

contrasted with System/370 IXF (858)

data type descriptions (827)

data types (821)

invalid column values (837)

invalid data type (826), (832)

record types (801), (804)

valid data type (825)

PC/IXF file

format (798)

PC/IXF file format

moving data across platforms (748)

PC/IXF file import

data type-specific rules (842)

general rules (830)

with forcein (855)

PC/IXF record type

application (819)

column descriptor (813)

data (816)

header (807)

table (810)

pending states (711)

performance

import utility (634)

load utility (717)

privileges

required for AutoLoader utility (733)

required for export utility (555)

required for import utility (585)

required for load utility (651)

Quick Beginnings for OS/2 (897)

Quick Beginnings for UNIX (898)

Quick Beginnings for Windows NT (899)

reclen (615), (684)

record length indicator (802)

record type, PC/IXF

application (820)

column descriptor (814)

data (817)

header (808)

table (811)

record types

PC/IXF (800), (805)

recreating an exported table

export utility (558)

import utility (592)

Replication Guide and Reference (889)

rules governing PC/IXF file import (829), (841)

sample ASC file (792)

sample DEL file (782)

SELECT statement

in EXPORT command (562)

semantics

forcein, code page (849)

forcein, data type (853)

forcein, general (847)

setting up document server (914)

splitting data (730)

SQL Getting Started (890)

SQL messages (868)

SQL Reference (891)

SQL-UEXPT-OUT structure (564)

SQLCODE (869)

SQLSTATE (870)

SQLUIMPT-IN structure (601)

SQLUIMPT-OUT structure (602)

SQLULOAD-IN structure (660)

SQLULOAD-OUT structure (661)

states

backup pending (712)

check pending (713)

delete pending (714)

load pending (715)

striptblanks (616), (685)

striptnulls (617), (686)

structure

delimited ASCII (DEL) file (781)

non-delimited ASCII (ASC) file (791)

summary table

import restriction (637)

syntax diagrams (767)

System Monitor Guide and Reference (892)

System/370 IXF (860)

contrasted with PC/IXF (859)

table load delete start log record (706)

table record, PC/IXF (809)

temporary files

LOAD (657)

load utility (702)

totalfreespace (674)

traverse order (582)

default (761)

typed tables (760)

user-specified (762)

Troubleshooting Guide (893)

typed tables

data movement examples (764)

export utility (757)

import utility (758)

moving data between (756)

selection during data movement (763)

traverse order (583), (759)

usedefaults (610), (675)

user-defined distinct types (UDTs)

import utility (596)

utility file formats (774)

valid PC/IXF data type (823)

variables

syntax for (770)

warning messages (864)

What's New (894)

worksheet file format (WSF) (861)

WSF file

format (863)

WSF file format

moving data across platforms (750)

[ Top of Page | Previous Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]