Open Group Standard
DRDA, Version 5, Volume 3:
Distributed Data Management (DDM) Architecture
The Open Group
© July 2011, The Open Group
All rights reserved.
No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in
any form or by any means, electronic, mechanical, photocopying, recording or otherwise,
without the prior permission of the copyright owners.
This documentation and the software to which it relates are derived in part from copyrighted
materials supplied by International Business Machines. Neither International Business Machines
nor The Open Group makes any warranty of any kind with regard to this material, including but
not limited to, the implied warranties of merchantability and fitness for a particular purpose.
The Open Group shall not be liable for errors contained herein, or for any direct or indirect,
incidental, special, or consequential damages in connection with the furnishing, performance, or
use of this material.
Open Group Standard
DRDA, Version 5, Volume 3: Distributed Data Management (DDM) Architecture
ISBN: 1-931624-93-3
Document Number: C114
Published in the U.K. by The Open Group, July 2011.
Any comments relating to the material contained in this document may be submitted to:
The Open Group
Apex Plaza
Forbury Road
Reading
Berkshire, RG1 1AX
United Kingdom
or by Electronic Mail to:
OGSpecs@opengroup.org
ii
Open Group Standard (2011)
Contents
Chapter
Chapter
1
1.1
1.2
1.3
2
2.1
2.2
2.3
2.3.1
2.3.2
2.3.3
2.3.4
2.3.5
2.3.6
2.3.7
2.4
2.4.1
2.4.2
2.4.3
2.4.4
2.5
2.5.1
2.5.2
2.5.3
2.5.4
2.5.5
2.5.6
2.5.7
2.5.8
Chapter
3
The DRDA Specification ................................................................
DRDA Reference .....................................................................................
The FD:OCA Reference ..........................................................................
The DDM Reference ................................................................................
Introduction to DDM .......................................................................
DDM Architecture...................................................................................
DDM is an Open Architecture...............................................................
Benefits of Using DDM...........................................................................
Reduced Programming Costs.............................................................
Reduced Data Redundancy ................................................................
More Timely Information....................................................................
Local/Remote Transparency ..............................................................
Better Resource Management.............................................................
Data Integrity ........................................................................................
Standardization ....................................................................................
The Basic Structure of DDM ..................................................................
The Language of DDM........................................................................
DDM Components ...............................................................................
How DDM Works ................................................................................
The DDM Relational Database Model ..............................................
DDM Programming Techniques ...........................................................
Data ........................................................................................................
Object .....................................................................................................
Server .....................................................................................................
Manager.................................................................................................
Connectivity..........................................................................................
DDM Object-Oriented Programming ...............................................
DDM Dictionaries ................................................................................
Using the DDM Reference Manual....................................................
Terms .........................................................................................................
ABBREVIATIONS ......................................................................................
ABNUOWRM .............................................................................................
ACCDMG ....................................................................................................
ACCRDB ......................................................................................................
ACCRDBRM ...............................................................................................
ACCSEC .......................................................................................................
ACCSECRD .................................................................................................
AGENT ........................................................................................................
AGNCMDPR ...............................................................................................
AGNPRMRM ..............................................................................................
AGNRPYPR ................................................................................................
APPCMNFL ................................................................................................
APPCMNI....................................................................................................
DRDA, Version 5, Volume 3: Distributed Data Management (DDM) Architecture
1
2
2
3
7
7
8
8
8
8
9
9
9
9
10
10
10
10
11
12
14
14
14
14
15
19
23
26
28
31
32
41
42
43
49
52
57
59
63
64
66
67
70
iii
Contents
APPCMNT ..................................................................................................
73
APPSRCCD .................................................................................................
76
APPSRCCR..................................................................................................
83
APPSRCER ..................................................................................................
88
APPTRGER .................................................................................................
92
ARMCORR ..................................................................................................
97
ARRAY .........................................................................................................
98
ASSOCIATION ........................................................................................... 100
ATMIND ...................................................................................................... 101
ATTLST ........................................................................................................ 102
BGNATMCHN ............................................................................................ 103
BGNBND ..................................................................................................... 105
BGNBNDRM ............................................................................................... 112
BIN ............................................................................................................... 113
BINDR.......................................................................................................... 114
BITDR .......................................................................................................... 116
BITSTRDR ................................................................................................... 117
BNDCHKEXS.............................................................................................. 118
BNDCHKONL ............................................................................................. 119
BNDCPY ...................................................................................................... 120
BNDCRTCTL ............................................................................................... 126
BNDDPLY ................................................................................................... 127
BNDERRALW ............................................................................................. 131
BNDEXPOPT .............................................................................................. 132
BNDEXSOPT .............................................................................................. 133
BNDEXSRQR.............................................................................................. 134
BNDNERALW ............................................................................................. 135
BNDOPT...................................................................................................... 136
BNDOPTNM ............................................................................................... 137
BNDOPTVL ................................................................................................ 138
BNDSQLSTT ............................................................................................... 139
BNDSTTASM .............................................................................................. 144
BOOLEAN ................................................................................................... 145
BUFINSIND ................................................................................................ 146
BYTDR ......................................................................................................... 148
BYTSTRDR.................................................................................................. 149
CCSID .......................................................................................................... 150
CCSIDDBC .................................................................................................. 151
CCSIDMBC ................................................................................................. 152
CCSIDMGR ................................................................................................. 153
CCSIDSBC ................................................................................................... 156
CCSIDXML ................................................................................................. 157
CHRDR ........................................................................................................ 158
CHRSTRDR ................................................................................................. 159
CLASS .......................................................................................................... 160
CLSQRY ....................................................................................................... 167
CMDATHRM .............................................................................................. 172
CMDCHKRM .............................................................................................. 173
CMDCMPRM ............................................................................................. 175
CMDNSPRM .............................................................................................. 176
CMDSRCID ................................................................................................. 178
CMDTRG ..................................................................................................... 179
iv
Open Group Standard (2011)
Contents
CMDVLTRM ............................................................................................... 180
CMMRQSRM.............................................................................................. 181
CMMTYP .................................................................................................... 182
CMNAPPC .................................................................................................. 183
CMNLYR ..................................................................................................... 193
CMNMGR ................................................................................................... 195
CMNOVR .................................................................................................... 200
CMNSYNCPT ............................................................................................. 201
CMNTCPIP ................................................................................................. 213
CNNTKN ..................................................................................................... 219
CNSVAL ....................................................................................................... 220
CNTQRY ...................................................................................................... 221
CODPNT ..................................................................................................... 232
CODPNTDR................................................................................................ 233
COLLECTION ............................................................................................. 235
COMMAND ................................................................................................ 237
CONCEPTS ................................................................................................. 240
CONSTANT ................................................................................................. 241
CRRTKN ...................................................................................................... 242
CSTBITS ...................................................................................................... 243
CSTMBCS .................................................................................................... 244
CSTSBCS ..................................................................................................... 245
CSTSYSDFT ................................................................................................ 246
DATA ........................................................................................................... 247
DCESEC ....................................................................................................... 248
DCESECOVR .............................................................................................. 249
DCESECTKN .............................................................................................. 253
DCTIND ...................................................................................................... 254
DCTINDEN ................................................................................................. 255
DDM ............................................................................................................ 256
DDMID ........................................................................................................ 257
DDMOBJ ..................................................................................................... 258
DECDELCMA ............................................................................................. 260
DECDELPRD .............................................................................................. 261
DECPRC ...................................................................................................... 262
DEFINITION ............................................................................................... 263
DEFLST........................................................................................................ 264
DEPERRCD ................................................................................................. 266
DFTDATFMT .............................................................................................. 267
DFTFMTXML ............................................................................................. 268
DFTPKG ...................................................................................................... 270
DFTRDBCOL .............................................................................................. 271
DFTTIMFMT .............................................................................................. 272
DFTVAL ....................................................................................................... 273
DGRIOPRL .................................................................................................. 275
DHENC ........................................................................................................ 276
DIAGLVL ..................................................................................................... 281
DICTIONARY ............................................................................................. 283
DMYBLKDATFMT ..................................................................................... 285
DMYCMADATFMT ................................................................................... 286
DMYHPNDATFMT ................................................................................... 287
DMYPRDDATFMT .................................................................................... 288
DRDA, Version 5, Volume 3: Distributed Data Management (DDM) Architecture
v
Contents
DMYSLHDATFMT .................................................................................... 289
DRPPKG ...................................................................................................... 290
DSCERRCD ................................................................................................. 294
DSCINVRM ................................................................................................ 296
DSCRDBTBL ............................................................................................... 298
DSCSQLSTT................................................................................................ 302
DSS ............................................................................................................... 306
DSSFMT ...................................................................................................... 316
DTAMCHRM .............................................................................................. 318
DTAOVR ..................................................................................................... 319
DUPQRYOK................................................................................................ 320
DYNDTAFMT ............................................................................................. 321
EDTASECOVR ............................................................................................ 323
ELMCLS ....................................................................................................... 329
ENCALG ...................................................................................................... 330
ENCKEYLEN .............................................................................................. 331
ENDATMCHN ............................................................................................ 332
ENDBND ..................................................................................................... 334
ENDCHNTYP ............................................................................................. 338
ENDDTARM ............................................................................................... 339
ENDQRYRM ............................................................................................... 340
ENDREF ...................................................................................................... 341
ENDUOWRM ............................................................................................. 342
ENUCLS ...................................................................................................... 344
ENULEN ...................................................................................................... 345
ENUVAL ...................................................................................................... 346
ERROR ......................................................................................................... 348
ETIME .......................................................................................................... 349
EURDATFMT ............................................................................................. 350
EURTIMFMT .............................................................................................. 351
EUSRIDDTA ............................................................................................... 352
EUSRIDNWPWD ....................................................................................... 354
EUSRIDONL ............................................................................................... 355
EUSRIDPWD .............................................................................................. 356
EUSRNPWDDTA ....................................................................................... 357
EUSRPWDDTA .......................................................................................... 359
EXCSAT ....................................................................................................... 361
EXCSATRD ................................................................................................. 367
EXCSQLIMM .............................................................................................. 368
EXCSQLSET................................................................................................ 374
EXCSQLSTT................................................................................................ 378
EXPALL ........................................................................................................ 391
EXPNON ..................................................................................................... 392
EXPREOPT ................................................................................................. 393
EXPYES ....................................................................................................... 394
EXTDTA ...................................................................................................... 395
EXTDTAOVR .............................................................................................. 396
EXTENSIONS ............................................................................................. 397
EXTNAM ..................................................................................................... 398
FALSE ........................................................................................................... 399
FDOCA ........................................................................................................ 400
FDODSC ...................................................................................................... 402
vi
Open Group Standard (2011)
Contents
FDODSCOFF .............................................................................................. 403
FDODTA ...................................................................................................... 404
FDODTAOFF .............................................................................................. 405
FDOEXT ...................................................................................................... 406
FDOOBJ ....................................................................................................... 407
FDOOFF ...................................................................................................... 408
FDOPRMOFF ............................................................................................. 409
FDOTRPOFF ............................................................................................... 410
FIELD ........................................................................................................... 411
FIXROWPRC .............................................................................................. 412
FORGET ...................................................................................................... 418
FRCFIXROW ............................................................................................... 419
FREPRVREF ................................................................................................ 420
FREREFNOT ............................................................................................... 421
FREREFNOW.............................................................................................. 422
FREREFOPT................................................................................................ 423
FRERFLCHK ............................................................................................... 424
GETNXTCHK.............................................................................................. 425
GETNXTLEN .............................................................................................. 430
GETNXTREF ............................................................................................... 431
HELP ............................................................................................................ 432
HEXDR ........................................................................................................ 433
HEXSTRDR ................................................................................................. 434
HMSBLKTIMFMT ...................................................................................... 435
HMSCLNTIMFMT ..................................................................................... 436
HMSCMATIMFMT .................................................................................... 437
HMSPRDTIMFMT ..................................................................................... 438
IGNORABLE ............................................................................................... 439
INDEX ......................................................................................................... 440
INFO ............................................................................................................ 441
INHERITANCE ........................................................................................... 442
INHERITED ................................................................................................ 447
INSTANCE_OF ........................................................................................... 449
INTRDBRQS ............................................................................................... 450
INTTKNRM ................................................................................................. 453
IPADDR ....................................................................................................... 454
ISODATFMT ............................................................................................... 455
ISOLVLALL ................................................................................................. 456
ISOLVLCHG ................................................................................................ 457
ISOLVLCS .................................................................................................... 458
ISOLVLNC ................................................................................................... 459
ISOLVLRR ................................................................................................... 460
ISOTIMFMT................................................................................................ 461
JISDATFMT ................................................................................................. 462
JISTIMFMT ................................................................................................. 463
JULBLKDATFMT........................................................................................ 464
JULCMADATFMT...................................................................................... 465
JULHPNDATFMT ...................................................................................... 466
JULPRDDATFMT ....................................................................................... 467
JULSLHDATFMT ....................................................................................... 468
KERSEC ....................................................................................................... 469
KERSECOVR .............................................................................................. 470
DRDA, Version 5, Volume 3: Distributed Data Management (DDM) Architecture
vii
Contents
KERSECPPL ................................................................................................ 474
KERSECTKN ............................................................................................... 475
LENGTH ...................................................................................................... 476
LMTBLKPRC ............................................................................................... 478
LOCDATFMT.............................................................................................. 486
LOCTIMFMT .............................................................................................. 487
LOGNAME .................................................................................................. 488
LOGTSTMP ................................................................................................. 489
LSTCHK ....................................................................................................... 490
LVLCMP ...................................................................................................... 491
MAGNITUDE ............................................................................................. 496
MANAGER.................................................................................................. 497
MAXBLKEXT.............................................................................................. 499
MAXLEN ..................................................................................................... 500
MAXRSLCNT ............................................................................................. 501
MAXSCTNBR ............................................................................................. 502
MAXVAL...................................................................................................... 503
MDYBLKDATFMT ..................................................................................... 504
MDYCMADATFMT ................................................................................... 505
MDYHPNDATFMT ................................................................................... 506
MDYPRDDATFMT .................................................................................... 507
MDYSLHDATFMT .................................................................................... 508
MEDDTASZ ................................................................................................ 509
MGRDEPRM .............................................................................................. 510
MGRLVL ...................................................................................................... 511
MGRLVLLS ................................................................................................. 513
MGRLVLN ................................................................................................... 514
MGRLVLOVR ............................................................................................. 516
MGRLVLRM ............................................................................................... 517
MGRNAM ................................................................................................... 518
MGROVR .................................................................................................... 519
MINLEN ...................................................................................................... 522
MINLVL ....................................................................................................... 523
MINVAL ....................................................................................................... 524
MONITOR ................................................................................................... 525
MONITORID .............................................................................................. 528
MONITORRD ............................................................................................. 529
MTLEXC ...................................................................................................... 531
MTLINC ....................................................................................................... 532
NAMDR ....................................................................................................... 533
NAME .......................................................................................................... 534
NAMSYMDR .............................................................................................. 535
NBRROW .................................................................................................... 537
NCHARDR .................................................................................................. 538
NCHRSTRDR.............................................................................................. 539
NEWPASSWORD ....................................................................................... 540
NIL................................................................................................................ 541
NOTE ........................................................................................................... 542
NUMBER ..................................................................................................... 543
NWPWDSEC ............................................................................................... 544
OBJDSS ........................................................................................................ 545
OBJECT ........................................................................................................ 549
viii
Open Group Standard (2011)