709 | 30 Jun 2014 @ 09:24 PDT | Tools | Reply | TPT DSN Error | Yes, it was related to 64-bit TPT.
The Microsoft driver needed something set explicitly whereas the DataDirect driver did not (accepted our default setting).
We always recommend that you ... |
708 | 30 Jun 2014 @ 04:28 PDT | Tools | Reply | TPT DSN Error | In the meantime, you can always download a free 15-day evaluation copy of the DataDirect drivers.
|
707 | 30 Jun 2014 @ 04:27 PDT | Tools | Reply | TPT DSN Error | Actually, 15.00.00.02 may not have been released yet.
Looks like it is schedule for mid-July.
|
706 | 30 Jun 2014 @ 04:23 PDT | Tools | Reply | TPT DSN Error | This is a known issue and has been fixed in 15.00.00.02 (you are running 15.00.00.00).
Please download the latest 15.00 patch/efix.
Thanks!
|
705 | 30 Jun 2014 @ 11:25 PDT | Tools | Reply | TPT load failure - Please suggest | We fix issues all of the time.
We are currently in development for the 15.10 release.
This means that bug fixes have occurred for 13.0, 13.10, 14.0, 14.10, and 15.0.
When bugs are found in newer... |
704 | 30 Jun 2014 @ 09:30 PDT | Tools | Reply | z/OS Mainframe TPT RECFM=FB versus LRECL=VB | I am told by the developers that this issue has been fixed.
You will need at least 13.10.00.13, but always best to upgrade to the latest efix.
I posted the latest versions above.
To be s... |
703 | 30 Jun 2014 @ 09:24 PDT | Tools | Reply | z/OS Mainframe TPT RECFM=FB versus LRECL=VB | First let me clear up one thing.
Indicator bytes are never written at the end of a record.
What you are seeing are pad bytes written out.
I have our mainframe developer looking into this.
Clear... |
702 | 27 Jun 2014 @ 05:06 PDT | Tools | Reply | z/OS Mainframe TPT RECFM=FB versus LRECL=VB | Did you try adding up the column sizes by hand?
The operator is reporting 383 bytes.
That 383 might include the indicator bytes.
Which means the actual record length being written out is 375.
W... |
701 | 27 Jun 2014 @ 01:46 PDT | Tools | Reply | z/OS Mainframe TPT RECFM=FB versus LRECL=VB | Just checked. Here are the latest patches:
TPT Infrastructure 13.10.00.19
TPT Export Operator 13.10.00.07
TPT Load Operator 13.10.00.05
TPT Stream Operator 13.10.00.09
TPT Update Operator 13.1... |
700 | 27 Jun 2014 @ 01:22 PDT | Tools | Reply | z/OS Mainframe TPT RECFM=FB versus LRECL=VB | I believe the latest patch is #15, #16 or #17.
I cannot list all of the bug fixes (too many).
I understand that you are on an enterprise system, but if you have access to a single test system and... |
699 | 27 Jun 2014 @ 11:33 PDT | Tools | Reply | TPT load failure - Please suggest | Please post the script you are using.
Thanks!
|
698 | 27 Jun 2014 @ 10:54 PDT | Tools | Reply | z/OS Mainframe TPT RECFM=FB versus LRECL=VB | Those are not indicator bytes. They might be garbage characters.
We have made several bug fixes in this area.
Please upgrade to the latest version of TPT 13.10 and re-run the job and see if the p... |
697 | 27 Jun 2014 @ 10:10 PDT | Tools | Reply | Qlikview TPT Connector | You mention that you are using "QVX_TPTConnector", but the output shows FastExport. FastExport is not part of any TPT connector. They are different products.
However, for this pa... |
696 | 27 Jun 2014 @ 10:03 PDT | Tools | Reply | TPT load failure - Please suggest | Please upgrade to the latest efix version and try again.
If the problem persists, let me know (and let me know what version you used).
|
695 | 25 Jun 2014 @ 11:28 PDT | Tools | Reply | TPT load failure - Please suggest | What exact version of 13.0?
We have released several patches since its GCA version.
And 13.0 is not an officially supported version of TPT, so my first response is for you to update TPT to the la... |
694 | 19 Jun 2014 @ 12:02 PDT | Tools | Reply | Running multiple concurrent TPT INSERTER jobs on one server - seeing long wind-down | I would need to see the script(s), and the command lines.
Are you running 12 different TPT scripts?
Did you give each job its own unique name?
Are the jobs loading different target tables?
What... |
693 | 19 Jun 2014 @ 11:18 PDT | Tools | Reply | TPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>'; | The reason for the DATE not working is because the data for that column is being exported in ANSI format (equivalent to a CHAR(10)) whereas the target table is being interpreted as the standard Ter... |
692 | 18 Jun 2014 @ 02:51 PDT | Tools | Reply | TPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>'; | Just to warn you: EasyLoader is a means to load data only. You would have to drop tables and create tables outside of that tool.
If you would rather have a single script to do that, then stick wit... |
691 | 18 Jun 2014 @ 02:24 PDT | Tools | Reply | TPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>'; | I will look into the issue you are having, but in the meantime, I have a question.
If all you are doing is moving data from one table to another, have you tried using the "EasyLoader" fe... |
690 | 18 Jun 2014 @ 11:33 PDT | Tools | Reply | TPT Load Operator Table Lock | Please explain your concern about the locks on the AMPs for that table.
If you are concerned about the amount of time the locks remain on the table, then the FastLoad or MultiLoad protocol should ... |
689 | 17 Jun 2014 @ 03:59 PDT | Tools | Reply | TPT Load Operator Table Lock | I suppose it might depend on how much data is loaded and how much time you spent on the original job.
If the original job loaded 90% of the data, you might be better off unlocking the tabl... |
688 | 16 Jun 2014 @ 12:13 PDT | Tools | Reply | Will TPT INSERTER operator lock the target table if an INSERT step fails? | No, the INSERTER operator will not leave the table in a locked state.
That is because it uses plain SQL sessions to load the table.
The LOAD operator uses the FastLoad protocol and that protocol ... |
687 | 16 Jun 2014 @ 10:08 PDT | Tools | Reply | EXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement | The only check we make is a comparison between the the result of the SELECT statement and the schema definition (the target table definition is immaterial; the DBS will do any necessary conversions... |
686 | 11 Jun 2014 @ 12:24 PDT | Tools | Reply | TPT Export to Mainframe File - RDBMS error 3177 | Ok, I see that you are using this for the Export operator:
INTEGER MAXRESPSIZE = 1048575, &nbs... |
685 | 09 Jun 2014 @ 09:07 PDT | Tools | Reply | TPT - Format = text example | Will your data have tab characters?
You can specify the delimiter as:
VARCHAR TextDelimiter = 'TAB'
(Yes, I know; strange)
If not, we have an undocumented featur... |