Open topic with navigation

TIBCO® Patterns 6.1.2

# Usage

As Patterns Data Transfer Tool is a command-line based, the following command is used for data transfer:

    java [jvm_options] -jar  PDTT.jar  source_server  target_server  [-i]

Commands | Description
--- | ---
`jvm_options` | Any applicable options for your Java Virtual Machine
`source_server` | Patterns installation that data is transferred from
`target_server` | Patterns installation that data is transferred to
`-i` | Objects that already exist on the target server do not cause an error

source_server and target_server both take the form:

`version:hostname:port[:SSL]`

Option | Description
--- | ---
version | Version of the Patterns server. E.g. 5.8
hostname | DNS-name or IP-address where the Patterns server is running
port | TCP port the Patterns server is listening on
SSL | Use SSL-encrypted communications

Example:

    java –jar pdtt.jar 5.6:localhost:8051:SSL  5.8:otherhost:5055

This transfers from a version 5.6 Patterns server to a version 5.8 Patterns server. The 5.6 Patterns server uses SSL-encrypted communications on port 5051 on the local host. The 5.8 Patterns server uses plain-text communications on port 5055 on machine “otherhost”. Since -i is not specified, any object that already exists on otherhost will cause an error.

## A Sample Run of Patterns Data Transfer Tool

We’ll use PDTT to transfer data from a Patterns instance on machine “z440” to another instance on the local machine.

Using the NSC command-line tool, we can see the tables on the source instance:

    java -jar NSC.jar -host z440 -port 5051 -cmd tbllist

    >>> nsc start.
    List: GENERIC
    DBDESCRIPTOR: join--names
    CHECKPOINT_STATUS: Last Checkpoint: 2022/05/11-10:31:33
    TRAN_ID: 0
    TRAN_OBJ_STATE: 1
    DBINFO:
    DBNUMFIELDS: 6
    FIELDNAMES: ["last","first","ssn","street","city","zip"]
    FIELDTYPES: [5, 5, 5, 5, 5, 5]
    FIELDBYTELCOUNTS: [337, 281, 486, 930, 506, 270]
    FIELDCHARLCOUNTS: [337, 281, 486, 930, 506, 270]
    CHARMAPS: ["=STD=","=STD=","=STD=","=STD=","=STD=","=STD="]
    DBGIPFILTER: true
    DBGIPGPU: false
    GIPGRAMLEN: 3
    DBSORTFILTER: false
    DBPSIFILTER: false
    DBNUMRECORDS: 54
    DBKEYTREEKBYTES: 12
    DBRECFIELDKBYTES: 3
    DBHEADERKBYTES: 130
    DBIDXTOTALKBYTES: 644
    DBTOTALKBYTES: 1814
    PROCTOTALKBYTES: 334076
    TABLE_TYPE: Child
    PARENT_TBL: join--states

    List: GENERIC
    DBDESCRIPTOR: join--states
    CHECKPOINT_STATUS: Last Checkpoint: 2022/05/11-10:31:33
    TRAN_ID: 0
    TRAN_OBJ_STATE: 1
    DBINFO:
    DBNUMFIELDS: 4
    FIELDNAMES: ["codeIdx","name","flower","latin-flower"]
    FIELDTYPES: [5, 5, 5, 5]
    FIELDBYTELCOUNTS: [100, 422, 647, 800]
    FIELDCHARLCOUNTS: [100, 422, 647, 800]
    CHARMAPS: ["=STD=","=STD=","=STD=","=STD="]
    DBGIPFILTER: true
    DBGIPGPU: false
    GIPGRAMLEN: 3
    DBSORTFILTER: false
    DBPSIFILTER: false
    DBNUMRECORDS: 50
    DBKEYTREEKBYTES: 12
    DBRECFIELDKBYTES: 2
    DBHEADERKBYTES: 130
    DBIDXTOTALKBYTES: 3833
    DBTOTALKBYTES: 5001
    PROCTOTALKBYTES: 334076
    TABLE_TYPE: Parent
    CHILD_TBLS: ["join--zips","join--names"]

    List: GENERIC
    DBDESCRIPTOR: join--zips
    CHECKPOINT_STATUS: Last Checkpoint: 2022/05/11-10:31:33
    TRAN_ID: 0
    TRAN_OBJ_STATE: 1
    DBINFO:
    DBNUMFIELDS: 4
    FIELDNAMES: ["ZipCodeType","City","StateIdx","Location"]
    FIELDTYPES: [5, 5, 5, 5]
    FIELDBYTELCOUNTS: [438, 531, 106, 1020]
    FIELDCHARLCOUNTS: [438, 531, 106, 1020]
    CHARMAPS: ["=STD=","=STD=","=STD=","=STD="]
    DBGIPFILTER: true
    DBGIPGPU: false
    GIPGRAMLEN: 3
    DBSORTFILTER: false
    DBPSIFILTER: false
    DBNUMRECORDS: 56
    DBKEYTREEKBYTES: 12
    DBRECFIELDKBYTES: 2
    DBHEADERKBYTES: 130
    DBIDXTOTALKBYTES: 1201
    DBTOTALKBYTES: 2370
    PROCTOTALKBYTES: 334076
    TABLE_TYPE: Child
    PARENT_TBL: join—states
    >>> nsc end.

After the transfer, following command is used to see the tables on the target instance :

    java -jar NSC.jar -host localhost -port 5051 -cmd tbllist

    //Tables on target server//
    >>> nsc start.
    List: GENERIC
    DBDESCRIPTOR: join--names
    OBJ_ID: 56485e82-8513-4a14-9b8f-9c79184bb62c
    CHECKPOINT_STATUS: Never Checkpointed
    TRAN_ID: 0
    TRAN_OBJ_STATE: 1
    DBINFO:
    DBNUMFIELDS: 6
    FIELDNAMES: ["last","first","ssn","street","city","zip"]
    FIELDTYPES: [5, 5, 5, 5, 5, 5]
    FIELDBYTELCOUNTS: [337, 281, 486, 930, 506, 270]
    FIELDCHARLCOUNTS: [337, 281, 486, 930, 506, 270]
    CHARMAPS: ["=STD=","=STD=","=STD=","=STD=","=STD=","=STD="]
    DBGIPFILTER: true
    DBGIPGPU: false
    GIPGRAMLEN: 3
    DBSORTFILTER: false
    DBPSIFILTER: false
    DBNUMRECORDS: 54
    DBKEYTREEKBYTES: 12
    DBRECFIELDKBYTES: 3
    DBHEADERKBYTES: 130
    DBIDXTOTALKBYTES: 644
    DBTOTALKBYTES: 1816
    TABLE_TYPE: Child
    PARENT_TBL: join--states

    List: GENERIC
    DBDESCRIPTOR: join--states
    OBJ_ID: 1b95de52-4dd1-4863-ba6f-fe2e02a7b80f
    CHECKPOINT_STATUS: Never Checkpointed
    TRAN_ID: 0
    TRAN_OBJ_STATE: 1
    DBINFO:
    DBNUMFIELDS: 4
    FIELDNAMES: ["codeIdx","name","flower","latin-flower"]
    FIELDTYPES: [5, 5, 5, 5]
    FIELDBYTELCOUNTS: [100, 422, 647, 800]
    FIELDCHARLCOUNTS: [100, 422, 647, 800]
    CHARMAPS: ["=STD=","=STD=","=STD=","=STD="]
    DBGIPFILTER: true
    DBGIPGPU: false
    GIPGRAMLEN: 3
    DBSORTFILTER: false
    DBPSIFILTER: false
    DBNUMRECORDS: 50
    DBKEYTREEKBYTES: 12
    DBRECFIELDKBYTES: 2
    DBHEADERKBYTES: 130
    DBIDXTOTALKBYTES: 3833
    DBTOTALKBYTES: 5003
    TABLE_TYPE: Parent
    CHILD_TBLS: ["join--names","join--zips"]

    List: GENERIC
    DBDESCRIPTOR: join--zips
    OBJ_ID: 88d2b00b-faf6-4cbd-9506-b3d2e8abc697
    CHECKPOINT_STATUS: Never Checkpointed
    TRAN_ID: 0
    TRAN_OBJ_STATE: 1
    DBINFO:
    DBNUMFIELDS: 4
    FIELDNAMES: ["ZipCodeType","City","StateIdx","Location"]
    FIELDTYPES: [5, 5, 5, 5]
    FIELDBYTELCOUNTS: [414, 515, 106, 996]
    FIELDCHARLCOUNTS: [414, 515, 106, 996]
    CHARMAPS: ["=STD=","=STD=","=STD=","=STD="]
    DBGIPFILTER: true
    DBGIPGPU: false
    GIPGRAMLEN: 3
    DBSORTFILTER: false
    DBPSIFILTER: false
    DBNUMRECORDS: 54
    DBKEYTREEKBYTES: 12
    DBRECFIELDKBYTES: 2
    DBHEADERKBYTES: 130
    DBIDXTOTALKBYTES: 1201
    DBTOTALKBYTES: 2372
    TABLE_TYPE: Child
    PARENT_TBL: join--states
    >>> nsc end.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® Patterns

Copyright © 2010-2025. Cloud Software Group, Inc. All Rights Reserved.