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.
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
|04:56||What is the WebSphere MQ File Transfer Edition (FTE) Database Logger?|
|06:26||Do I need any authority to run WebSphere MQ FTE Database Logger?|
|08:35||Step 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:56||How do I install and configure WebSphere MQ FTE Database Logger on stand-alone setup?|
|19:38||How do I install the WebSphere MQ FTE JEE Database Logger?|
|26:49||Could 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:45||Can we use the FTE Web Gateway to monitor all FTE transactions, or only the ones processed through the FTE Web Gateway?|
|31:47||We would like to know how much space is expected to grow the database roughly in a year?|
|32:33||Are there any downsides to using the COORD, CMD and the AGT Agent as one QMgr instead of three?|
|34:08||What 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:19||Regarding 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:46||Do you have any future plans to implement any other databases other than Oracle and DB2?|
|43:35||End of Call|
Panel of Experts:
|Snezhana Johnson||Advisory Software Engineer, WMQ L2 support|
|Jason Simmons||Staff Software Engineer, WMQ L2 support|
|Belinda Fuller||Advisory Software Engineer, WMQ L2 support|
|Pranav Mehta||Staff Software Engineer, WMQ L2 support|
|Gareth Bottomley||Staff Software Engineer, WMQ FTE developer|
|Paul Slater||WebSphere L3 Service|
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.
WebSphere Support Technical Exchange
Time Zone Converter
WebSphere MQ FTE System Requirements
Securing WebSphere MQ FTE V7
WebSphere MQ FTE Step-byStep Configuration and Setup
What to do if messages are building up on your SYSTEM.M
IC70596: GHOST FOLDERS FILLING UP /VAR/MQM FILESYSTEM D
Working with WebSphere Message Broker
|Business Integration||WebSphere MQ File Transfer Edition||SupportPac||AIX, HP-UX, Linux, Solaris, Windows||7.0.4, 7.0.3, 7.0.2, 7.0.1, 7.0||All Editions|
WMQ MQ FTE