IBM Support

Ask the Experts Replay: WebSphere MQ File Transfer Edition (FTE) Database Logger - Configuration, Usage and Troubleshooting

Webcasts


Abstract

This Ask the Experts session addresses pre-submitted and live questions from customers on the configuration usage and troubleshooting tips of the WebSphere MQ File Transfer Edition (FTE) Database Logger.

Content

Ask the Experts sessions are conducted in a question and answer format. The table below provides a time index (minutes:seconds) to the recording and describes the questions or topics discussed. You can fast forward to any question using the time index, a table containing the panel of experts is also included.


To play or download the audio of this Ask the Experts session, see the Audio Section of this document.

See the Related Information Section of this document for a list of documents referenced during the presentation.




Ask the Experts session
12 April 2012 - 11:00 a.m. - 12:00 p.m. EDT

TimeQuestions asked
00:00Silence
00:30General introduction
03:57Technical introduction
04:56What is the WebSphere MQ File Transfer Edition (FTE) Database Logger?
06:26Do I need any authority to run WebSphere MQ FTE Database Logger?
08:35Step 3 of the “Installing the WebSphere MQ File Transfer Edition stand-alone database logger” states that I need to run ftelog_tables_db2.sql to create the required database tables. However, when I run the sql file against my DB2 database, I get the error message “SQL0670N The row length of the table exceeded a limit of “4005” byte.” How do I resolve this?
10:56How do I install and configure WebSphere MQ FTE Database Logger on stand-alone setup?
19:38How do I install the WebSphere MQ FTE JEE Database Logger?
26:49Could you please provide a list of links where I might find white papers, technical manuals, business cases and other useful documentation for WebSphere MQ FTE and the Database Logger?
28:45Can we use the FTE Web Gateway to monitor all FTE transactions, or only the ones processed through the FTE Web Gateway?
31:47We would like to know how much space is expected to grow the database roughly in a year?
32:33Are there any downsides to using the COORD, CMD and the AGT Agent as one QMgr instead of three?
34:08What are the difference are between what the database logger logs vs MQAttach and its ability to audit its transfers through the database, and is it possible to leverage the DBLogger within MQAttach for the front end capability?
35:19Regarding the Oracle database, we know that the DBLogger logs into the database, is there any script to control the process so that the database doesn't grow all the time, or do we need to write our own script for that?
41:46Do you have any future plans to implement any other databases other than Oracle and DB2?
42:50Closing remarks
43:35End of Call

Panel of Experts:
Snezhana JohnsonAdvisory Software Engineer, WMQ L2 support
Jason SimmonsStaff Software Engineer, WMQ L2 support
Belinda FullerAdvisory Software Engineer, WMQ L2 support
Pranav MehtaStaff Software Engineer, WMQ L2 support
Gareth BottomleyStaff Software Engineer, WMQ FTE developer
Paul SlaterWebSphere L3 Service


Audio

To replay the recording of this 43 minutes conference call, click on Download Audio (5.0MB - audio in MP3 format). Right-click and select Save As to store the file on your local computer for later playback. Remember that you can fast forward to any question using the time index.

[{"Product":{"code":"SSFKSJ","label":"WebSphere MQ"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"WMQ File Transfer Edition","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.0.4;7.0.3;7.0.2;7.0.1;7.0","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSEP7X","label":"WebSphere MQ File Transfer Edition"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"SupportPac","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.0.4;7.0.3;7.0.2;7.0.1;7.0","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}}]

Product Synonym

WMQ MQ FTE

Document Information

Modified date:
17 June 2018

UID

swg27024368