Index

Special Characters
A B C D E F G H I J L M N O P Q R S T U V W
Special Characters
  • (FFDC) first-failure data capture (3702)
    • A
  • access path (3292) See also index
  • protection, system-managed (3336)
  • access plan
  • definition (3907)
  • SQL package (3908)
  • accessing AS/400 data via DB2 Connect (3987)
  • accounting
  • planning for (2608)
  • active job
  • working with (3552)
  • active jobs
  • working with (3064), (3549)
  • Add Communications Entry (ADDCMNE) command (2831)
  • Add Relational Database Directory Entry (ADDRDBDIRE) command (2952), (3246), (3494), (3735)
  • Add Sphere of Control Entry (ADDSOCE) command (2722)
  • ADDCMNE (Add Communications Entry) command (2830)
  • adding
  • communications entry (2835)
  • relational database directory entry (2956), (3498), (3739)
  • sphere of control entry (2726)
  • ADDRDBDIRE (Add Relational Database Directory Entry) command (2951), (3245), (3493), (3734)
  • ADDSOCE (Add Sphere of Control Entry) command (2721)
  • ADDSVRAUTE command (2842)
  • administration and operation (3037)
  • administration task
  • canceling work (3212)
  • displaying job log (3069)
  • finding a distributed relational database job (3077)
  • job accounting (3199)
  • operating systems remotely (3085)
  • starting and stopping remote systems (3088)
  • submitting remote commands (3092)
  • working with active jobs (3058)
  • working with commitment definitions (3066)
  • working with jobs (3041)
  • working with user jobs (3049)
  • adopted authority
  • displaying objects using (2878)
  • running jobs under (2877)
  • Advanced Peer-to-Peer Networking (APPN)
  • configuration example (2687)
  • configuration list (2805)
  • conversation level security (2813)
  • DRDA support (2629)
  • location security (2785)
  • remote location list (2671), (2806)
  • session level security (2754)
  • SNA conversation security (2814)
  • Advanced Program-to-Program Communications (APPC)
  • DRDA support (2626)
  • alert
  • definition (2638)
  • for distributed relational database (3672)
  • problem handling (3668)
  • set up (2705)
  • types (2639)
  • working with (3669)
  • alert default focal point (ALRDFTFP) parameter (2712)
  • alert primary focal point (ALRPRIFP) parameter (2713)
  • alert support
  • focal point
  • definition (2640)
  • set up (2742)
  • overview (2637)
  • sphere of control
  • definition (2642)
  • set up (2744)
  • analyzing
  • RW trace data (4008)
  • APPC (Advanced Program-to-Program Communications)
  • DRDA support (2627)
  • application
  • considerations (2593)
  • designing (2586)
  • requirements (2592)
  • Application Development Tools (ADT) (3013)
  • application program
  • binding (3905)
  • compiling (3902)
  • creating an SQL package (3923), (3927)
  • deleting an SQL package (3938)
  • handling problems
  • SQLCODE (3648)
  • SQLSTATE (3649)
  • host program (3831)
  • host variable (3832)
  • precompiler commands (3842)
  • precompiling (3833)
  • program references (3913)
  • SQL naming convention (3762)
  • SQLCODE (3657)
  • SQLSTATE (3658)
  • system naming convention (3759)
  • temporary source file member (3838)
  • testing and debugging (3910)
  • application programming examples (3942)
  • application requester
  • commitment control for DDM jobs (3828)
  • definition (2528)
  • problem diagnosis (3578)
  • program start request failure message (3642)
  • relational database directory (2947)
  • application requester driver (ARD) programs (2564)
  • application server (3584)
  • commitment control for DDM jobs (3827)
  • definition (2527)
  • object security (2850)
  • problem diagnosis (3583)
  • program start request failure message (3643)
  • relational database directory (2948)
  • starting a service job (3709), (3710)
  • using a default user profile (2827)
  • applications
  • writing Distributed Relational Database (3751)
  • APPN (Advanced Peer-to-Peer Networking)
  • configuration example (2688)
  • configuration list (2807)
  • conversation level security (2815)
  • DRDA support (2630)
  • location security (2786)
  • remote location list (2672), (2808)
  • session level security (2755)
  • SNA conversation security (2816)
  • APPN location list (2670), (2809)
  • ARD (application requester driver) programs (2565)
  • AS/400 data
  • accessing via DB2 Connect (3991)
  • AS/400 Distributed Relational Database
  • managing an (2569)
  • AS/400 files
  • journaling (3992)
  • AS/400 QCCSID value (3958)
  • ASP (auxiliary storage pool) (3279)
  • auditing
  • Add Relational Database Directory Entry (ADDRDBDIRE) (3250)
  • ADDRDBDIRE (Add Relational Database Directory Entry) (3249)
  • Change Relational Database Directory Entry (CHGRDBDIRE) (3252)
  • CHGRDBDIRE (Change Relational Database Directory Entry) (3251)
  • Display Relational Database Directory Entry (DSPRDBDIRE) (3254)
  • DSPRDBDIRE (Display Relational Database Directory Entry) (3253)
  • relational database directory (3226)
  • Remove Relational Database Directory Entry (RMVRDBDIRE) (3256)
  • RMVRDBDIRE (Remove Relational Database Directory Entry) (3255)
  • Work with Relational Database Directory Entries (WRKRDBDIRE) (3258)
  • WRKRDBDIRE (Work with Relational Database Directory Entries) (3257)
  • authority
  • restoring (3429), (3447), (3458)
  • saving (3446)
  • authorization method
  • group profile (2896)
  • autostart job (2907)
  • auxiliary storage pool (ASP) (3278)
  • availability
  • data (3507)
    • B
  • backup
  • planning for (2616)
  • batch job (2904)
  • binding an application (3906)
  • blocking
  • factors that affect (3559)
  • blocks
  • size factors (3565)
    • C
  • C/400
  • programming
  • examples (3952)
  • capabilities
  • distributed relational database (2585)
  • catalog
  • definition (2526)
  • CCSID
  • conversion considerations (3961), (3967)
  • DB2 (3968)
  • DB2 Server for VM database managers (3969)
  • DB2/2 licensed program (3962)
  • CCSID (Coded Character Set Identifier)
  • CCSID (coded character set identifier) (2561)
  • allowed values (3813)
  • changing (3818)
  • DB2 considerations (3979)
  • DB2 Server for VM considerations (3980)
  • how data is translated (3822)
  • in user profile (3815)
  • overview (3809)
  • tagging (3811), (3820)
  • CCSID considerations (3956)
  • CDRA (Character Data Representation Architecture) (2559), (3808)
  • Change Job (CHGJOB) command (3159)
  • Change Network Attributes (CHGNETA) command (2654), (2707)
  • DDMACC parameter (2852), (2854)
  • Change Object Auditing Value (CHGOBJAUD) command (3260)
  • Change Relational Database Directory Entry (CHGRDBDIRE) command (2988), (3242), (3729)
  • Change Subsystem Description (CHGSBSD) command (2933)
  • changed object
  • saving (3387)
  • changing
  • job (3163)
  • network attributes (2658), (2711), (2858)
  • object auditing value (3264)
  • relational database directory entry (2992), (3733)
  • subsystem description (2937)
  • character conversion (2555)
  • Character Data Representation Architecture (CDRA) (2558), (3804)
  • with DRDA (2552)
  • checksum protection (3283)
  • CHGDDMTCPA command (2843), (2894), (2998)
  • CHGJOB (Change Job) command (3158)
  • CHGNETA (Change Network Attributes) command (2653), (2706)
  • DDMACC parameter (2853)
  • CHGOBJAUD (Change Object Auditing Value) command (3259)
  • CHGRDBDIRE (Change Relational Database Directory Entry) command (2987), (3241), (3728)
  • CHGSBSD (Change Subsystem Description) command (2932)
  • COBOL/400
  • programming
  • examples (3950)
  • code page (2562)
  • Coded Character Set Identifier (CCSID)
  • coded character set identifier (CCSID) (2560)
  • allowed values (3812)
  • changing (3817)
  • DB2 considerations (3977)
  • DB2 Server for VM considerations (3978)
  • how data is translated (3821)
  • in user profile (3814)
  • overview (3807)
  • tagging (3810), (3819)
  • collection
  • definition (2522)
  • in SQL naming convention (3764)
  • SQL communication area (SQLCA) (3656)
  • collection and table creation
  • DB2/400 Query Manager and SQL Development Kit needed for (3999)
  • command support
  • DDM (4035)
  • command, CL
  • Add Communications Entry (ADDCMNE) (2833)
  • Add Relational Database Directory Entry (ADDRDBDIRE) (2954), (3248), (3496), (3737)
  • Add Sphere of Control Entry (ADDSOCE) (2724)
  • ADDCMNE (Add Communications Entry) (2832)
  • ADDRDBDIRE (Add Relational Database Directory Entry) (2953), (3247), (3495), (3736)
  • ADDSOCE (Add Sphere of Control Entry) (2723)
  • Change Job (CHGJOB) (3161)
  • Change Network Attributes (CHGNETA) (2656), (2709)
  • DDMACC parameter (2856)
  • Change Object Auditing Value (CHGOBJAUD) (3262)
  • Change Relational Database Directory Entry (CHGRDBDIRE) (2990), (3244), (3731)
  • Change Subsystem Description (CHGSBSD) (2935)
  • CHGJOB (Change Job) (3160)
  • CHGNETA (Change Network Attributes) (2655), (2708)
  • DDMACC parameter (2855)
  • CHGOBJAUD (Change Object Auditing Value) (3261)
  • CHGRDBDIRE (Change Relational Database Directory Entry) (2989), (3243), (3730)
  • CHGSBSD (Change Subsystem Description) (2934)
  • Create Configuration List (CRTCFGL)
  • secure-location entry (2802)
  • Create Controller Description (APPC) (CRTCTLAPPC) (2770), (2781), (2793)
  • Create Device Description (APPC) (CRTDEVAPPC) (2764)
  • Create Structured Query Language C (CRTSQLC) (3861)
  • Create Structured Query Language C ILE (CRTSQLCI) (3863)
  • Create Structured Query Language COBOL (CRTSQLCBL) (3865)
  • Create Structured Query Language COBOL ILE (CRTSQLCBLI) (3867)
  • Create Structured Query Language FORTRAN (CRTSQLFTN) (3873)
  • Create Structured Query Language Package (CRTSQLPKG) (3932)
  • Create Structured Query Language PL/I (CRTSQLPLI) (3859)
  • Create Structured Query Language RPG (CRTSQLRPG) (3871)
  • Create Structured Query Language RPG ILE (CRTSQLRPGI) (3869)
  • CRTCFGL (Create Configuration List)
  • secure-location entry (2801)
  • CRTCTLAPPC (Create Controller Description (APPC)) (2769), (2780), (2792)
  • CRTDEVAPPC (Create Device Description (APPC)) (2763)
  • CRTSQLC (Create Structured Query Language C) (3860)
  • CRTSQLCBL (Create Structured Query Language COBOL) (3864)
  • CRTSQLCBLI (Create Structured Query Language COBOL ILE) (3866)
  • CRTSQLCI (Create Structured Query Language C ILE) (3862)
  • CRTSQLFTN (Create Structured Query Language FORTRAN) (3872)
  • CRTSQLPKG (Create Structured Query Language Package) (3931)
  • CRTSQLPLI (Create Structured Query Language PL/I) (3858)
  • CRTSQLRPG (Create Structured Query Language RPG) (3870)
  • CRTSQLRPGI (Create Structured Query Language RPG ILE) (3868)
  • Display Job Log (DSPJOBLOG) (3074)
  • Display Journal (DSPJRN) (2612), (3303)
  • Display Message Descriptions (DSPMSGD) (3626)
  • Display Program References (DSPPGMREF) (3184), (3917)
  • Display Programs that Adopt (DSPPGMADP) (2884)
  • Display Relational Database Directory Entry (DSPRDBDIRE) (2983), (3240), (3488)
  • Display Sphere of Control Status (DSPSOCSTS) (2736)
  • DSPJOBLOG (Display Job Log) (3073)
  • DSPJRN (Display Journal) (2611), (3302)
  • DSPMSGD (Display Message Descriptions) (3625)
  • DSPPGMADP (Display Programs that Adopt) (2883)
  • DSPPGMREF (Display Program References) (3183), (3916)
  • DSPRDBDIRE (Display Relational Database Directory Entry) (2982), (3239), (3487)
  • DSPSOCSTS (Display Sphere of Control Status) (2735)
  • End Job (ENDJOB) (3217)
  • End Request (ENDRQS) (3223)
  • ENDJOB (End Job) (3216)
  • ENDRQS (End Request) (3222)
  • Grant Object Authority (GRTOBJAUT) (2864)
  • GRTOBJAUT (Grant Object Authority) (2863)
  • RCLDDMCNV (Reclaim Distributed Data Management Conversations) (3149), (3176)
  • RCLRSC (Reclaim Resources) (3143), (3170)
  • Reclaim Distributed Data Management Conversations (RCLDDMCNV) (3150), (3177)
  • Reclaim Resources (RCLRSC) (3144), (3171)
  • Remove Relational Database Directory Entry (RMVRDBDIRE) (2976), (3236)
  • Remove Sphere of Control Entry (RMVSOCE) (2730)
  • Restore Authority (RSTAUT) (3428), (3457)
  • Restore Configuration (RSTCFG) (3422)
  • Restore Library (RSTLIB) (3404)
  • Restore Object (RSTOBJ) (3410), (3473), (3502)
  • Restore User Profiles (RSTUSRPRF) (3416), (3463)
  • Revoke Object Authority (RVKOBJAUT) (2870)
  • RMVRDBDIRE (Remove Relational Database Directory Entry) (2975), (3235)
  • RMVSOCE (Remove Sphere of Control Entry) (2729)
  • RSTAUT (Restore Authority) (3427), (3456)
  • RSTCFG (Restore Configuration) (3421)
  • RSTLIB (Restore Library) (3403)
  • RSTOBJ (Restore Object) (3409), (3472), (3501)
  • RSTUSRPRF (Restore User Profiles) (3415), (3462)
  • RVKOBJAUT (Revoke Object Authority) (2869)
  • SAVCHGOBJ (Save Changed Object) (3385)
  • Save Changed Object (SAVCHGOBJ) (3386)
  • Save Library (SAVLIB) (3323), (3374)
  • Save Object (SAVOBJ) (3329), (3380), (3479)
  • Save Save File Data (SAVSAVFDTA) (3392)
  • Save Security Data (SAVSECDTA) (3451)
  • Save System (SAVSYS) (3398), (3437)
  • SAVLIB (Save Library) (3322), (3373)
  • SAVOBJ (Save Object) (3328), (3379), (3478)
  • SAVSAVFDTA (Save Save File Data) (3391)
  • SAVSECDTA (Save Security Data) (3450)
  • SAVSYS (Save System) (3397), (3436)
  • SBMRMTCMD (Submit Remote Command) (3096), (3110), (3195)
  • authority restrictions (3102)
  • Start Commitment Control (STRCMTCTL) (3352)
  • Start Copy Screen (STRCPYSCRN) (3596)
  • Start Debug (STRDBG) (3721)
  • Start Journal Access Path (STRJRNAP) (3317)
  • Start Pass-Through (STRPASTHR) (3603)
  • Start Service Job (STRSRVJOB) (3715)
  • STRCMTCTL (Start Commitment Control) (3351)
  • STRCPYSCRN (Start Copy Screen) (3595)
  • STRDBG (Start Debug) (3720)
  • STRJRNAP (Start Journal Access Path) (3316)
  • STRPASTHR (Start Pass-Through) (3602)
  • STRSRVJOB (Start Service Job) (3714)
  • Submit Remote Command (SBMRMTCMD) (3097), (3111), (3196)
  • authority restrictions (3103)
  • Vary Configuration (VRYCFG) (2684), (3519)
  • VRYCFG (Vary Configuration) (2683), (3518)
  • Work with Active Jobs (WRKACTJOB) (3063), (3548)
  • Work with Configuration Status (WRKCFGSTS) (2678), (3513)
  • Work with Disk Status (WRKDSKSTS) (3542)
  • Work with Job (WRKJOB) (3046)
  • Work with Relational Database Directory Entries (WRKRDBDIRE) (2969), (3232)
  • Work with Sphere of Control (WRKSOC) (2718)
  • Work with System Status (WRKSYSSTS) (3536)
  • Work with User Jobs (WRKUSRJOB) (3054)
  • WRKACTJOB (Work with Active Jobs) (3062), (3547)
  • WRKCFGSTS (Work with Configuration Status) (2677), (3512)
  • WRKDSKSTS (Work with Disk Status) (3541)
  • WRKJOB (Work with Job) (3045)
  • WRKRDBDIRE (Work with Relational Database Directory Entries) (2968), (3231)
  • WRKSOC (Work with Sphere of Control) (2717)
  • WRKSYSSTS (Work with System Status) (3535)
  • WRKUSRJOB (Work with User Jobs) (3053)
  • command, precompiler
  • Create Structured Query Language C ILE (CRTSQLCI) (3891)
  • Create Structured Query Language COBOL (CRTSQLCBL) (3893)
  • Create Structured Query Language COBOL ILE (CRTSQLCBLI) (3897)
  • Create Structured Query Language FORTRAN (CRTSQLFTN) (3901)
  • Create Structured Query Language PL/I (CRTSQLPLI) (3889)
  • Create Structured Query Language RPG (CRTSQLRPG) (3895)
  • Create Structured Query Language RPG ILE (CRTSQLRPGI) (3899)
  • CRTSQLCBL (Create Structured Query Language COBOL) (3892)
  • CRTSQLCBLI (Create Structured Query Language COBOL ILE) (3896)
  • CRTSQLCI (Create Structured Query Language C ILE) (3890)
  • CRTSQLFTN (Create Structured Query Language FORTRAN) (3900)
  • CRTSQLPLI (Create Structured Query Language PL/I) (3888)
  • CRTSQLRPG (Create Structured Query Language RPG) (3894)
  • CRTSQLRPGI (Create Structured Query Language RPG ILE) (3898)
  • commitment control
  • journal management (3297)
  • lock levels (3340)
  • notify object (NFYOBJ) parameter (3345)
  • overview (2531)
  • record lock durations (3355)
  • starting (3341), (3353)
  • transaction recovery (3339)
  • with distributed relational database and DDM jobs (3825)
  • commitment definitions, defined (3068)
  • committed work
  • definition (2529)
  • communications
  • alert support (2636)
  • APPC support (2625)
  • APPN support (2628)
  • configuration
  • alerts (2703)
  • controller description (2667)
  • line description (2664)
  • location list (2669)
  • network interface description (2661)
  • steps (2652)
  • varying on or off (2673)
  • DDM and DRDA coexistence (2631), (3002)
  • DDM conversations (3116), (3121)
  • job (2905), (2940)
  • network considerations
  • for DRDA support (2649)
  • overview (2620)
  • communications entry
  • adding (2834)
  • communications tools (2621)
  • communications trace
  • messages (3693)
  • system service tools (SST) (3696)
  • compiling programs (3903)
  • concepts and terms (2539)
  • configuration
  • alerts (2704)
  • restoring (3423)
  • varying (2685), (3520)
  • configuration list
  • creating (2803)
  • configuration status
  • working with (2679), (3514)
  • configuring
  • alerts (2739)
  • APPN network nodes (2689)
  • communications
  • controller description (2668)
  • line description (2665)
  • network interface description (2662)
  • steps (2651)
  • Configuring a distributed relational database (2571)
  • configuring communications
  • network attributes (2659)
  • connected state (3779)
  • connecting to a secure database (2829)
  • connection
  • SQL (3771)
  • SQL versus network (3114)
  • connection failures (3644)
  • connection management (2594)
  • connection problems (3639)
  • connection state
  • CONNECT (Type 2) statement (3770)
  • connection states
  • activation group (3778)
  • distributed unit of work (3772)
  • remote unit of work (3769)
  • considerations
  • application programming (3753)
  • CCSID (3957)
  • controller description (APPC)
  • creating (2771), (2782), (2794)
  • controlling subsystem
  • definition (2911)
  • QBASE (2915)
  • QCTL (2919)
  • controlling which ID a job runs under (2826)
  • conversations
  • SNA versus TCP/IP (3115)
  • conversations, unprotected (3527)
  • conversion considerations
  • CCSID (3963), (3970)
  • DB2 (3971)
  • DB2 Server for VM database managers (3972)
  • DB2/2 licensed program (3964)
  • copying displays (3594)
  • Create Configuration List (CRTCFGL) command
  • secure-location entry (2800)
  • Create Controller Description (APPC) (CRTCTLAPPC) command (2768)
  • location-password entry (2779)
  • SECURELOC parameter (2791)
  • specifying an APPN location password (2778)
  • Create Device Description (APPC) (CRTDEVAPPC) command
  • LOCPWD parameter (2762)
  • specifying a location password (2761)
  • Create Structured Query Language C ILE (CRTSQLCI) command (3847)
  • Create Structured Query Language COBOL (CRTSQLCBL) command (3849)
  • Create Structured Query Language COBOL ILE (CRTSQLCBLI) command (3853)
  • Create Structured Query Language FORTRAN (CRTSQLFTN) command (3857)
  • Create Structured Query Language Package (CRTSQLPKG) command (3930)
  • Create Structured Query Language PL/I (CRTSQLPLI) command (3845)
  • Create Structured Query Language RPG (CRTSQLRPG) command (3851)
  • Create Structured Query Language RPG ILE (CRTSQLRPGI) command (3855)
  • creating
  • configuration list (2804)
  • controller description (APPC) (2772), (2783), (2795)
  • device description (APPC) (2766)
  • interactive SQL packages on DB2 Server for VM (3985)
  • structured query language package (3934)
  • cross-platform DRDB notes (3953)
  • CRTCFGL (Create Configuration List) command
  • secure-location entry (2799)
  • CRTCTLAPPC (Create Controller Description (APPC)) command (2767)
  • location-password entry (2777)
  • SECURELOC parameter (2790)
  • specifying an APPN location password (2776)
  • CRTDEVAPPC (Create Device Description (APPC)) command
  • LOCPWD parameter (2760)
  • specifying a location password (2759)
  • CRTSQLCBL (Create Structured Query Language COBOL) command (3848)
  • CRTSQLCBLI (Create Structured Query Language COBOL ILE) command (3852)
  • CRTSQLCI (Create Structured Query Language C ILE) command (3846)
  • CRTSQLFTN (Create Structured Query Language FORTRAN) command (3856)
  • CRTSQLPKG (Create Structured Query Language Package) command (3929)
  • CRTSQLPLI (Create Structured Query Language PL/I) command (3844)
  • CRTSQLRPG (Create Structured Query Language RPG) command (3850)
  • CRTSQLRPGI (Create Structured Query Language RPG ILE) command (3854)
  • current connection state (3774)
    • D
  • data
  • accessing via DB2 Connect (3990)
  • availability (3506)
  • blocked for better performance (3996)
  • character conversion (2557)
  • considerations (2601)
  • designing (2588)
  • failure (3676)
  • requirements (2600)
  • data availability and protection (3265)
  • data capture
  • FFDC (3701)
  • data conversion
  • noncharacter data (3824)
  • data entries
  • interpreting (4007)
  • data file utility (DFU) (3012)
  • data location
  • deciding (3556)
  • data needs
  • determining (2583)
  • data redundancy (3522)
  • data translation
  • CCSID (3806)
  • noncharacter data (3823)
  • database
  • security (2748)
  • database administration
  • canceling work (3213)
  • displaying job log (3070)
  • finding a distributed relational database job (3078)
  • job accounting (3200)
  • operating systems remotely (3086)
  • starting and stopping remote systems (3089)
  • submitting remote commands (3093)
  • working with
  • active jobs (3059)
  • commitment definitions (3067)
  • jobs (3042)
  • user jobs (3050)
  • database recovery
  • auxiliary storage pool (ASP) (3276)
  • checksum protection (3281)
  • converting journal receiver entries (3299)
  • disk failures (3274)
  • failure types (3266)
  • force-write ratio (3356)
  • journal management (3289)
  • methods (3269)
  • mirrored protection (3285)
  • rebuilding indexes (3308)
  • reducing index rebuilding time (3334)
  • uninterruptible power supply (3271)
  • database, improving performance through (3555)
  • DB2 (2545)
  • CCSID (3973)
  • conversion considerations (3974)
  • DB2 Connect (2547)
  • accessing AS/400 data (3989)
  • DB2 for VSE and VM (2546)
  • DB2 Server for VM
  • creating interactive SQL packages (3986)
  • DB2 Server for VM database managers
  • CCSID (3975)
  • conversion considerations (3976)
  • DB2/2 licensed program
  • CCSID (3965)
  • conversion considerations (3966)
  • DB2/400 Query Manager and SQL Development Kit
  • coexistence across DRDA platforms (3801)
  • collection and table creation (3998)
  • distributed relational database statements (3796)
  • DDM (distributed data management)
  • CHGJOB command (3157)
  • coexistence with DRDA support (2635)
  • DDMCNV job attribute (3135), (3156)
  • dropped conversations (3133)
  • dropping conversations (3120), (3124), (3140)
  • keeping conversations (3119)
  • keeping conversations active (3125), (3138)
  • moving data between AS/400 systems (3025)
  • reclaiming
  • conversations (3166)
  • resources (3167)
  • unused conversations (3132)
  • using copy file commands (3024)
  • DDM architecture command support (4034)
  • DDM error codes on FFDC (4033)
  • DDM file
  • setting up (3001)
  • DDM file access (3003)
  • DDM files
  • SQL commitment control (3826)
  • DDM job start message (3080)
  • DDMCNV (DDM conversations) job attribute (3136), (3153)
  • debug
  • starting (3722)
  • debugging and testing
  • application program (3912)
  • default collection name (3765)
  • default focal point
  • definition (2648)
  • default user (DFTUSR) parameter (2837)
  • defining
  • controller description (2666)
  • line description (2663)
  • network interface description (2660)
  • description
  • FFDC dump output (4031)
  • RW trace points (4012)
  • design
  • application (2591)
  • data (2590)
  • network (2589)
  • design for distributed relational database (2579)
  • developing
  • management strategy (2603)
  • device description (APPC)
  • creating (2765)
  • DFTUSR (default user) parameter (2836)
  • DFU (data file utility) (3011)
  • DISCONNECT (3128)
  • disk failure
  • auxiliary storage pool (ASP) (3280)
  • checksum protection (3284)
  • mirrored protection (3288)
  • disk status
  • working with (3543)
  • Display Job Log (DSPJOBLOG) command (3072)
  • Display Journal (DSPJRN) command (2610), (3301)
  • Display Message Descriptions (DSPMSGD) command (3624)
  • Display Program References (DSPPGMREF) command (3182), (3915)
  • Display Programs that Adopt (DSPPGMADP) command (2882)
  • Display Relational Database Directory Entry (DSPRDBDIRE) command (2981), (3238), (3486)
  • Display Sphere of Control Status (DSPSOCSTS) command (2734)
  • display, copying (3593)
  • displaying
  • job log (3076)
  • journal (2614), (3305)
  • message descriptions (3628)
  • objects (3180)
  • program references (3186), (3919)
  • programs that adopt (2886)
  • relational database directory entry (2985), (3490)
  • sphere of control status (2738)
  • distributed data management (DDM)
  • CHGJOB command (3155)
  • coexistence with DRDA support (2634)
  • DDMCNV job attribute (3134), (3154)
  • dropped conversations (3131)
  • dropping conversations (3118), (3122), (3139)
  • keeping conversations (3117)
  • keeping conversations active (3123), (3137)
  • moving data between AS/400 systems (3023)
  • reclaiming
  • conversations (3164)
  • resources (3165)
  • unused conversations (3130)
  • using copy file commands (3022)
  • distributed data management conversations
  • reclaiming (3151), (3178)
  • Distributed Relational Database
  • distributed relational database
  • administration and operation (3036)
  • managing (2570)
  • remote unit of work (3768)
  • set up (2898)
  • SQL specific to (3795)
  • Distributed Relational Database application
  • considerations for a Distributed Relational Database (3754)
  • programming considerations (3755)
  • Distributed Relational Database Architecture (DRDA) support
  • coexistence with DDM (2632)
  • current AS/400 support (2566)
  • overview (2540)
  • with CDRA (2554)
  • distributed relational database capabilities (2584)
  • distributed relational database problems
  • incorrect output (3576)
  • waiting, looping, performance
  • at the application requester (3581)
  • at the application server (3589)
  • distributed relational database security (2747)
  • distributed unit of work (DUW)
  • application design tips (2595)
  • definition (2536)
  • dormant connection state (3775)
  • DRDA (Distributed Relational Database Architecture) Level 2 support (2535)
  • DRDA (Distributed Relational Database Architecture) support
  • coexistence with DDM (2633)
  • current AS/400 support (2567)
  • level 1 support (2515)
  • level 2 support (2516)
  • overview (2541)
  • with CDRA (2553)
  • DRDA Connect Authorization Failure (3645)
  • DRDA listener program (3205)
  • DRDB
  • cross-platform (3954)
  • DROP PACKAGE statement (3941)
  • dropping a collection (3192)
  • DSPJOBLOG (Display Job Log) command (3071)
  • DSPJRN (Display Journal) command (2609), (3300)
  • DSPMSGD (Display Message Descriptions) command (3623)
  • DSPPGMADP (Display Programs that Adopt) command (2881)
  • DSPPGMREF (Display Program References) command (3181), (3914)
  • DSPRDBDIRE (Display Relational Database Directory Entry) command (2980), (3237), (3485)
  • DSPSOCSTS (Display Sphere of Control Status) command (2733)
  • dump, FFDC (4027)
  • DUW (distributed unit of work)
  • definition (2537)
    • E
  • EBCDIC (2563)
  • encoding, character conversion (2556)
  • End Job (ENDJOB) command (3215)
  • End Request (ENDRQS) command (3221)
  • End TCP/IP Server CL command (3207)
  • ending
  • job (3219)
  • request (3225)
  • ending SQL programs (3802)
  • ENDJOB (End Job) command (3214)
  • ENDRQS (End Request) command (3220)
  • ensuring data availability (3505)
  • environments
  • like (2549)
  • unlike (2551)
  • error log (3686)
  • FFDC data (3705)
  • error message
  • DRDA Connect Authorization Failure (3646)
  • error recovery
  • relational database (3268)
  • error reporting
  • alerts (3666)
  • communications trace (3692)
  • definition (4025)
  • DRDA supported alerts (3670)
  • first-failure data capture (4024)
  • printing a job log (3678)
  • printing an error log (3685)
  • trace jobs (3688)
  • example
  • alerts configuration
  • adding a sphere of control entry (2743)
  • at end nodes (2745)
  • creating (2741)
  • analyzing the RW trace data (4011)
  • APPN configuration
  • controller description, nonswitched (2694), (2700)
  • controller description, switched (2696), (2702)
  • network attributes (2692), (2697), (2698)
  • network node to network node (2690)
  • nonswitched line description (2693), (2699)
  • switched line description (2695), (2701)
  • configuring alert support (2740)
  • displaying program references (3188)
  • displaying SQL package references (3190)
  • FFDC dump (4029)
  • programming
  • C/400 language (3951)
  • COBOL/400 language (3949)
  • database setup (3945)
  • inserting data (3946)
  • RPG/400 language (3947)
  • spiffy corporation (2577)
  • submitting a remote command (3107)
  • examples (2994)
  • application programming (3944)
  • expectations and needs
  • identifying (2582)
  • explicit connection (3786)
    • F
  • factors that affect blocking (3558)
  • factors that affect query block size (3562)
  • failure data (3677)
  • FAQs from users of DB2 Connect (3988)
  • FFDC (first-failure data capture) (3674)
  • interpreting (4004)
  • FFDC data
  • interpreting (3704)
  • FFDC dump (4026)
  • files
  • journaling (3993)
  • finding first-failure data capture data (3699)
  • finding job logs from TCP/IP server prestart jobs (3681)
  • first-failure data capture (FFDC) (3673), (3700)
  • DDM error codes (4032)
  • dump output description (4030)
  • first-failure data capture data (FFDC)
  • interpreting (4005)
  • focal point
  • default (2646)
  • definition (2641)
  • primary (2645)
  • sphere of control (2643)
  • force-write ratio (3358)
    • G
  • getting data to report a failure (3675)
  • GRANT EXECUTE statement (2874)
  • Grant Object Authority (GRTOBJAUT) command (2862)
  • granting
  • object authority (2866)
  • GRTOBJAUT (Grant Object Authority) command (2861)
    • H
  • handling DRDB problems (3566)
  • held connection state (3776)
  • history log, displaying (3210)
  • host program
  • definition (3829)
  • host variables
  • definition (3830)
  • hung job (3191)
    • I
  • IBM-supplied subsystem
  • QBASE (2912)
  • QBATCH (2924)
  • QCMN (2922)
  • QCTL (2916)
  • QINTER (2920)
  • QSPL (2926)
  • QSYSWRK (2928)
  • identifying your needs and expectations (2580)
  • implicit connect (3784)
  • index
  • definition (2524)
  • journaling (3307)
  • journaling restrictions (3332)
  • rebuilding (3309)
  • recovering (3310)
  • saving and restoring (3433)
  • starting journaling (3312)
  • table design considerations (3333)
  • informational messages (3613)
  • interactive job (2903), (2941)
  • interactive SQL
  • moving data between systems (3016)
  • starting commitment control (3343)
  • interactive SQL and query management setup (3981)
  • Internet Protocol Security Protocol (IPSec) (2844)
  • interpreting
  • data entries
  • for the RW component of trace job (4006)
  • FFDC data (4002)
  • FFDC data from the error log (3703)
  • trace job (4001)
  • IPSec (Internet Protocol Security Protocol) (2845)
    • J
  • job
  • accounting (3201)
  • canceling (3211)
  • changing (3162)
  • ending (3218)
  • types (2902)
  • working with (3047)
  • job log
  • alerts (3679)
  • displaying (3075)
  • finding a job (3081)
  • job trace (3689)
  • jobs
  • working with active (3553)
  • journal
  • displaying (2613), (3304)
  • journal access path
  • starting (3318)
  • journal management
  • commitment control (3296)
  • indexes (3306)
  • journal receiver (3293)
  • overview (3291)
  • starting index journaling (3313)
  • stopping (3295)
  • journal receiver (3294)
  • journaling
  • AS/400 files (3994)
    • L
  • LCKLVL parameter (3348)
  • library
  • restoring (3405)
  • saving (3324), (3375)
  • like environment
  • definition (2548)
  • load data
  • into tables (3006)
  • using Query Management/400 (3008)
  • using DFU (data file utility) (3010)
  • using SQL (3007)
  • location security
  • APPC network (2787)
  • APPN network (2796)
  • secure-location entry (2798)
  • SECURELOC parameter (2789)
  • system verifies (2788)
  • which system verifies security (2797)
  • location, definition (2599)
  • loop problem
  • application requester (3580)
  • application server (3586)
    • M
  • management strategy
  • developing (2602)
  • managing an AS/400 Distributed Relational Database (2568)
  • MCH3402 exceptions, avoiding (3209)
  • message
  • Additional Message Information display (3620)
  • category descriptions (3617)
  • database accessed (3083)
  • DDM job start (3079)
  • distributed relational database (3637)
  • handling problems (3612)
  • informational (3610)
  • inquiry (3611)
  • program start request failure (3641)
  • severity code (3633)
  • target DDM job started (3084)
  • types (3632)
  • message category (3616)
  • message descriptions
  • displaying (3627)
  • migration of data from mainframes (3019), (3032)
  • mirrored protection (3287)
  • monitoring
  • relational database activity (3039)
  • moving data
  • between AS/400 systems (3014)
  • between unlike systems
  • using communications (3031)
  • using File Transfer Protocol (3033)
  • using OSI File Services/400 licensed program (3035)
  • using SQL functions (3029)
  • using tape or diskette (3030)
  • using TCP/IP Connectivity Utilities/400 licensed program (3034)
  • copying files with DDM (3021)
  • using copy file commands (3020)
  • using interactive SQL (3015)
  • using Query Management/400 (3017)
  • using save and restore (3026)
    • N
  • naming convention
  • default collection name (3766)
  • SQL (3763)
  • system (3760)
  • naming distributed relational database objects (3756)
  • national language support (3805)
  • needs and expectations
  • identifying (2581)
  • network
  • considerations (2598)
  • designing (2587)
  • improving performance through (3526)
  • requirements (2597)
  • network attributes
  • changing (2657), (2710), (2857)
  • network configuration example (2691)
  • network considerations
  • for DRDA support (2650)
  • network redundancy (3508)
  • NFYOBJ (notify object) parameter (3346)
  • notes
  • cross-platform DRDB (3955)
  • notify object (NFYOBJ) parameter (3347)
    • O
  • object
  • restoring (3411), (3474), (3503)
  • saving (3330), (3381), (3480)
  • object auditing value
  • changing (3263)
  • object authority
  • granting (2865)
  • revoking (2871)
  • object-related security
  • DDMACC parameter (2851)
  • objects
  • naming distributed relational database (3757)
  • operation and administration (3038)
  • operations, general
  • planning for (2604)
    • P
  • package management
  • SQL (3926)
  • packages
  • working with (3922)
  • pass-through
  • starting (3604)
  • password
  • in CONNECT statement (2817), (3788)
  • in interactive SQL (3791)
  • sending (2818), (3789), (3792)
  • using (2820)
  • performance
  • blocked query data (3997)
  • blocking (3560)
  • deciding data location (3557)
  • delays on connect (3590)
  • distributed relational database (3524)
  • factors affecting (3561)
  • improving through database (3554)
  • improving through the network (3525)
  • improving through the system (3531)
  • observing system (3532)
  • unprotected conversations (3529)
  • performance problems
  • application server (3587)
  • planning
  • backup (2618)
  • general operations (2605)
  • recovery (2619)
  • security (2607)
  • planning for distributed relational database (2578)
  • precompile process
  • commands (3843)
  • output listing (3836)
  • overview (3834)
  • SQL package (3840)
  • temporary source file member (3837)
  • precompiler command
  • Create Structured Query Language C ILE (CRTSQLCI) (3877)
  • Create Structured Query Language COBOL (CRTSQLCBL) (3879)
  • Create Structured Query Language COBOL ILE (CRTSQLCBLI) (3883)
  • Create Structured Query Language FORTRAN (CRTSQLFTN) (3887)
  • Create Structured Query Language PL/I (CRTSQLPLI) (3875)
  • Create Structured Query Language RPG (CRTSQLRPG) (3881)
  • Create Structured Query Language RPG ILE (CRTSQLRPGI) (3885)
  • CRTSQLCBL (Create Structured Query Language COBOL) (3878)
  • CRTSQLCBLI (Create Structured Query Language COBOL ILE) (3882)
  • CRTSQLCI (Create Structured Query Language C ILE) (3876)
  • CRTSQLFTN (Create Structured Query Language FORTRAN) (3886)
  • CRTSQLPLI (Create Structured Query Language PL/I) (3874)
  • CRTSQLRPG (Create Structured Query Language RPG) (3880)
  • CRTSQLRPGI (Create Structured Query Language RPG ILE) (3884)
  • prestart job (2908)
  • prestart jobs, using (3208)
  • primary focal point
  • definition (2647)
  • sphere of control setup (2714)
  • problem
  • system-detected (3571)
  • user-detected (3574)
  • problem analysis, planning for (2615)
  • problem handling (4023)
  • Additional Message Information display (3618)
  • alerts (3667)
  • Analyze Problem (ANZPRB) command (3664)
  • application problems (3647)
  • communications trace (3695)
  • copying displays (3592)
  • displaying message description (3621)
  • distributed relational database messages (3634)
  • DRDA supported alerts (3671)
  • error log (3687)
  • isolating distributed relational database problems (3575)
  • job log (3680)
  • job trace (3691)
  • message category (3614)
  • message severity (3629)
  • overview (3568)
  • problem log (3663)
  • program start request failure (3638)
  • system messages (3606)
  • system-detected problems (3569)
  • user-detected problems (3572)
  • using display station pass-through (3599)
  • wait, loop, performance problems
  • application requester (3577)
  • application server (3582)
  • working with users (3591)
  • problem log (3665)
  • problems
  • handling (3567)
  • program references
  • displaying (3185), (3918)
  • program start request failure (3640)
  • programming considerations
  • for a Distributed Relational Database application (3752)
  • programming examples
  • application (3943)
  • programs that adopt
  • displaying (2885)
  • protection
  • system-managed access-path (3337)
  • protection strategies for distributed databases (2889)
    • Q
  • QBASE controlling subsystem (2913)
  • QCCSID
  • system value (3960)
  • QCNTSRVC (3726), (3742), (3745), (3748)
  • QCTL controlling subsystem (2917)
  • QCTLSBSD system value (2930)
  • QPSRVDMP FFDC spooled file (4028)
  • QRETSVRSEC system value (2840)
  • query block size
  • factors that affect the (3563)
  • query data
  • blocked for better performance (3995)
  • query management and interactive SQL setup (3982)
  • Query Management/400 function
  • loading data into tables (3009)
  • moving data between AS/400 systems (3018)
    • R
  • RCLDDMCNV (Reclaim Distributed Data Management Conversations) command (3147), (3174)
  • RCLRSC (Reclaim Resources) command (3141), (3168)
  • RDB (relational database) parameter
  • implicit CONNECT (3782)
  • in CRTSQLPKG command (3936)
  • in relational database directory (2958)
  • Reclaim Distributed Data Management Conversations (RCLDDMCNV) command (3148), (3175)
  • Reclaim Resources (RCLRSC) command (3142), (3169)
  • reclaiming
  • distributed data management conversations (3152), (3179)
  • resources (3146), (3173)
  • recovery
  • auxiliary storage pool (ASP) (3277)
  • checksum protection (3282)
  • disk failures (3275)
  • failure types (3267)
  • force-write ratio (3359)
  • journal management (3290)
  • methods (3270)
  • mirrored protection (3286)
  • planning for (2617)
  • uninterruptible power supply (3272)
  • redundancy
  • communications network (3509)
  • data (3523)
  • relational database
  • definition (2517)
  • relational database (RDB) parameter
  • implicit CONNECT (3783)
  • in CRTSQLPKG command (3937)
  • in relational database directory (2959)
  • relational database activity
  • monitoring (3040)
  • relational database directory
  • auditing (3227)
  • changing entries (2986)
  • commands (2950)
  • creating an output file (3484)
  • definition (2574)
  • displaying entries (2979)
  • local entry (2949)
  • optional parameters (2962)
  • RDB (relational database) parameter (2960)
  • removing entries (2972)
  • restoring (3492)
  • RMTLOCNAME parameter (2961)
  • saving (3483)
  • setting up (2946)
  • setup example (2993)
  • using CL programs (2995)
  • working with entries (2965)
  • relational database directory entries
  • working with (2970)
  • relational database directory entry
  • adding (2955), (3497), (3738)
  • changing (2991), (3732)
  • displaying (2984), (3489)
  • removing (2977)
  • relational database name
  • implicit CONNECT (3781)
  • in CRTSQLPKG command (3935)
  • in relational database directory (2957)
  • RELEASE (3129)
  • released connection state (3777)
  • remote command
  • submitting (3098), (3104), (3112), (3197)
  • remote procedure call (3799)
  • remote system operation
  • starting and stopping (3087)
  • submitting remote commands (3091)
  • remote unit of work (RUW) (3767)
  • definition (2533)
  • Remove Relational Database Directory Entry (RMVRDBDIRE) command (2974), (3234)
  • Remove Sphere of Control Entry (RMVSOCE) command (2728)
  • removing
  • relational database directory entry (2978)
  • sphere of control entry (2732)
  • request
  • ending (3224)
  • resources
  • reclaiming (3145), (3172)
  • Restore Authority (RSTAUT) command (3426), (3455)
  • Restore Configuration (RSTCFG) command (3420)
  • Restore Library (RSTLIB) command (3402)
  • Restore Object (RSTOBJ) command (3408), (3471), (3500)
  • moving data between AS/400 systems (3028)
  • Restore User Profiles (RSTUSRPRF) command (3414), (3461)
  • restoring
  • authority (3430), (3459)
  • configuration (3424)
  • from save file (3363)
  • from tape or diskette (3364)
  • indexes (3432)
  • library (3370), (3406)
  • object (3369), (3412), (3475), (3504)
  • relational database directory (3491)
  • security data (3441)
  • SQL packages (3467)
  • user profiles (3418), (3465)
  • REVOKE EXECUTE statement (2876)
  • Revoke Object Authority (RVKOBJAUT) command (2868)
  • revoking
  • object authority (2872)
  • RMVRDBDIRE (Remove Relational Database Directory Entry) command (2973), (3233)
  • RMVSOCE (Remove Sphere of Control Entry) command (2727)
  • rollback
  • definition (2532)
  • RPG/400
  • programming
  • examples (3948)
  • RSTAUT (Restore Authority) command (3425), (3454)
  • RSTCFG (Restore Configuration) command (3419)
  • RSTLIB (Restore Library) command (3401)
  • RSTOBJ (Restore Object) command (3407), (3470), (3499)
  • RSTUSRPRF (Restore User Profiles) command (3413), (3460)
  • RUNRMTCMD command (3004), (3090)
  • RUW (remote unit of work)
  • definition (2534)
  • RVKOBJAUT (Revoke Object Authority) command (2867)
  • RW trace data
  • analyzing (4009)
    • S
  • SAVCHGOBJ (Save Changed Object) command (3383)
  • Save Changed Object (SAVCHGOBJ) command (3384)
  • save file (3362)
  • save file data
  • saving (3393)
  • Save Library (SAVLIB) command (3321), (3372)
  • Save Object (SAVOBJ) command (3327), (3378), (3477)
  • moving data between AS/400 systems (3027)
  • Save Save File Data (SAVSAVFDTA) command (3390)
  • Save Security Data (SAVSECDTA) command (3449)
  • Save System (SAVSYS) command (3396), (3435)
  • saving
  • changed object (3367), (3388)
  • indexes (3431)
  • journal receivers (3298)
  • library (3325), (3366), (3376)
  • object (3331), (3365), (3382), (3481)
  • relational database directory (3482)
  • save file data (3368), (3394)
  • security data (3440), (3453)
  • SQL packages (3466)
  • system (3400), (3439)
  • to save file (3361)
  • to tape or diskette (3360)
  • SAVLIB (Save Library) command (3320), (3371)
  • SAVOBJ (Save Object) command (3326), (3377), (3476)
  • SAVSAVFDTA (Save Save File Data) command (3389)
  • SAVSECDTA (Save Security Data) command (3448)
  • SAVSYS (Save System) command (3395), (3434)
  • SBMRMTCMD (Submit Remote Command) command (3094), (3100), (3108), (3193)
  • SBMRMTCMD command (3005)
  • Secure Sockets Layer (SSL) (2846)
  • security
  • application
  • requester (2750), (2810), (2824)
  • server (2751), (2811), (2823)
  • assigning authority to users (2895)
  • auditing (3228)
  • consistent system levels across network (2752)
  • controlling access to objects (2849)
  • controlling which ID a job runs under (2825)
  • conversation level (2812)
  • default user profile (2822), (2890)
  • distributed database overview (2749)
  • for an AS/400 distributed relational database (2746)
  • location (2784)
  • object security (2888)
  • password (2821), (3790), (3793)
  • planning for (2606)
  • protection strategies (2887)
  • restoring profiles and authorities (3443)
  • saving profiles and authorities (3442)
  • session level (2753)
  • setting up (2997)
  • TCP/IP (2848)
  • security data
  • saving (3452)
  • server
  • application
  • starting a service job (3711)
  • server authorization entries (2841), (2999)
  • service job
  • on the application server (3708)
  • starting (3707), (3716)
  • session level security
  • APPC network (2756)
  • APPN network (2773)
  • creating a remote location list (2774)
  • LOCPWD (location password) parameter (2757)
  • specifying a location password during device configuration (2758)
  • specifying a location-password (2775)
  • setting QCNTSRVC as a TPN
  • on a DB2 Connect application requester (3747)
  • on a DB2 for OS/390 application requester (3744)
  • on a DB2 for VM application requester (3741)
  • on a DB2/400 application requester (3725)
  • setting up a distributed relational database (2897)
  • setup
  • interactive SQL (3983)
  • query management (3984)
  • size of query blocks
  • factors that affect the (3564)
  • SMAPP (system-managed access-path protection) (3338)
  • SNA (Systems Network Architecture) (2624)
  • special TPN for debugging APPC server jobs (3740)
  • sphere of control
  • definition (2644)
  • working with (2719)
  • sphere of control entry
  • adding (2725)
  • removing (2731)
  • sphere of control status
  • displaying (2737)
  • spiffy corporation example (2576)
  • spooled job (2906)
  • SQL CALL (3798)
  • SQL collection
  • definition (2523)
  • SQL naming convention (3761)
  • SQL package
  • access plan (3909)
  • adopted authority (2879)
  • creating with CRTSQLPKG (3928)
  • creating with CRTSQLxxx (3924)
  • creation as a result of precompile (3841)
  • definition (2575)
  • deleting (3939)
  • displaying objects used (3189)
  • for interactive SQL (3000)
  • restoring (3469)
  • saving (3468)
  • SQL package management (3925)
  • SQL packages
  • working with (3921)
  • SQL program
  • adopted authority (2880)
  • compiling (3904)
  • displaying objects used (3187)
  • example listing
  • CRTSQLPKG (3655)
  • precompiler (3652)
  • SQLCODE (3654)
  • SQLSTATE (3653)
  • handling problems
  • SQLCODE (3650)
  • SQLSTATE (3651)
  • starting commitment control (3342)
  • SQL programs, ending (3803)
  • SQL specific to distributed relational database (3794)
  • SQL statement
  • CALL (3800)
  • CONNECT
  • explicit (3787)
  • implicit (3785)
  • DISCONNECT (3126)
  • DROP PACKAGE (3940)
  • GRANT EXECUTE (2873)
  • precompiling (3835)
  • RELEASE (3127)
  • REVOKE EXECUTE (2875)
  • SQL terms
  • corresponding system terms (2520)
  • definition list (2519)
  • SQLCODE error code
  • error handling (3659)
  • for distributed relational database (3660)
  • SQLSTATE error code
  • error handling (3661)
  • for distributed relational database (3662)
  • SSL (Secure Sockets Layer) (2847)
  • SST (system service tools) (3698)
  • Start Commitment Control (STRCMTCTL) command (3344), (3350)
  • Start Copy Screen (STRCPYSCRN) command (3597)
  • Start Debug (STRDBG) command (3719)
  • Start Journal Access Path (STRJRNAP) command (3315)
  • Start Pass-Through (STRPASTHR) command (3601)
  • Start Service Job (STRSRVJOB) command (3713)
  • Start TCP/IP Server CL command (3206)
  • starting
  • commitment control (3354)
  • debug (3723)
  • journal access path (3319)
  • pass-through (3605)
  • service job (3717)
  • starting a service job (3706)
  • states
  • SQL connection (3773)
  • stored procedure (3797)
  • STRCMTCTL (Start Commitment Control) command (3349)
  • STRCPYSCRN (Start Copy Screen) command (3598)
  • STRDBG (Start Debug) command (3718)
  • STRJRNAP (Start Journal Access Path) command (3314)
  • STRPASTHR (Start Pass-Through) command (3600)
  • STRSRVJOB (Start Service Job) command (3712)
  • structured query language package
  • creating (3933)
  • Submit Remote Command (SBMRMTCMD) command (3095), (3101), (3109), (3194)
  • submitting
  • remote command (3099), (3105), (3113), (3198)
  • subsystem
  • controlling (2909)
  • definition (2900)
  • IBM-supplied (2910)
  • QBASE (2914), (2942)
  • QBATCH (2925)
  • QCMN (2923), (2945)
  • QCTL (2918), (2943)
  • QCTLSBSD system value (2931)
  • QINTER (2921), (2944)
  • QSPL (2927)
  • QSYSWRK (2929)
  • setup considerations (2939)
  • subsystem description
  • changing (2936)
  • supported connections (2573)
  • supported products
  • DB2 (2542)
  • DB2 Connect (2544)
  • DB2 for VSE and VM (2543)
  • system
  • improving performance through (3530)
  • naming convention (3758)
  • saving (3399), (3438)
  • terms (2521)
  • system message
  • Additional Message Information display (3619)
  • category (3615)
  • displaying message description (3622)
  • for distributed relational database (3635)
  • informational (3608)
  • inquiry (3609)
  • returned SQLCODE (3636)
  • severity code (3631)
  • types (3607), (3630)
  • system performance
  • applicator requester problem (3588)
  • force-write ratio (3357)
  • system service tools (SST) (3697)
  • system status
  • working with (3537)
  • system value
  • QCCSID (3959)
  • system-detected problem (3570)
  • system-managed access-path protection (SMAPP) (3335)
  • Systems Network Architecture (SNA) (2623)
    • T
  • table
  • definition (2518)
  • table creation
  • DB2/400 Query Manager and SQL Development Kit needed for (4000)
  • target system
  • submit remote commands (3106)
  • TCP/IP (2572), (2596)
  • finding joblogs (3683)
  • finding server job logs (3682)
  • finding server jobs (3082)
  • forcing joblogs to be saved (3684)
  • security (2838), (2996)
  • server job attributes (2860)
  • service jobs (3724)
  • user profile (2893)
  • user profiles (2839), (2859)
  • working with server jobs (3057)
  • TCP/IP Communication Support Concepts (3203)
  • TCP/IP communications, establishing (3204)
  • temporary source file member (3839)
  • terminology (3202)
  • terms and concepts (2538)
  • testing and debugging
  • application program (3911)
  • tools
  • communications (2622)
  • TPN
  • setting QCNTSRVC (3727), (3743), (3746), (3749)
  • trace
  • communications (3694)
  • job (3690)
  • trace data
  • analyzing (4010)
  • trace job data
  • interpreting (4003)
  • trace point
  • description (4013)
  • built in datastream from LOB table (4021)
  • partial send data stream (4016), (4017)
  • receive data stream (4014)
  • saved in inbound LOB table (4022)
  • saved in outbound LOB table (4020)
  • send data stream (4015)
  • successful fetch (4018)
  • unsuccessful fetch (4019)
  • transaction program name parameter
  • in AS/400 (TNSPGM) (2964)
  • in SNA (TPN) (2963)
    • U
  • unconnected state (3780)
  • uninterruptible power supply (3273)
  • unit of work
  • definition (2530)
  • unlike environment
  • definition (2550)
  • unprotected conversations (3528)
  • user jobs
  • working with (3055)
  • user profile
  • CCSID (3816)
  • default (2828), (2891)
  • on application server (2892)
  • restoring (3445)
  • saving (3444)
  • user profiles
  • restoring (3417), (3464)
  • user-detected problem (3573)
  • using passwords (2819)
    • V
  • Vary Configuration (VRYCFG) command (2674), (2682), (3517)
  • varying
  • configuration (2686), (3521)
  • view
  • definition (2525)
  • recovering (3311)
  • VRYCFG (Vary Configuration) command (2681), (3516)
    • W
  • wait problem
  • application requester (3579)
  • application server (3585)
  • work management
  • job types (2901)
  • subsystem setup (2938)
  • subsystems (2899)
  • Work with Active Jobs (WRKACTJOB) command (3061), (3546)
  • Work with Configuration Status (WRKCFGSTS) command (2676), (3511)
  • Work with Disk Status (WRKDSKSTS) command (3540)
  • Work with Job (WRKJOB) command (3044)
  • Work with Relational Database Directory Entries (WRKRDBDIRE) command (2967), (3230)
  • Work with Sphere of Control (WRKSOC) command (2716)
  • Work with System Status (WRKSYSSTS) command (3534)
  • Work with User Jobs (WRKUSRJOB) command (3052)
  • working with
  • active jobs (3065), (3550), (3551)
  • configuration status (2680), (3515)
  • disk status (3544)
  • job (3048)
  • relational database directory entries (2971)
  • sphere of control (2720)
  • system status (3538)
  • user jobs (3056)
  • working with SQL packages (3920)
  • writing Distributed Relational Database applications (3750)
  • WRKACTJOB (Work with Active Jobs) command (3060), (3545)
  • WRKCFGSTS (Work with Configuration Status) command (2675), (3510)
  • WRKDSKSTS (Work with Disk Status) command (3539)
  • WRKJOB (Work with Job) command (3043)
  • WRKRDBDIRE (Work with Relational Database Directory Entries) command (2966), (3229)
  • WRKSOC (Work with Sphere of Control) command (2715)
  • WRKSYSSTS (Work with System Status) command (3533)
  • WRKUSRJOB (Work with User Jobs) command (3051)

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