PI61491: USING THE (INVALID) 'V' OPTION WITH TRACE (-TV) ON A DATABASE ADAPTER COMMAND LINE MAY CAUSE AN ADAPTER CONNECTION FAILURE

APAR status

• Closed as program error.

Error description

• This issue is caused by using an invalid trace modifyer
  as part of the adapter connection string, which is:
  
  -CONNECT orac -USER scott -PASSWORD tiger -TV+
  C:\Simple\Database\Test1.dbl
  
  A database trace file is created (if the maps is trigger from
  the Launcher) in the map directory, and called 'dtxtrig1.dbl'.
  It contains the error:
  
  Error returned by OCISessionBegin, errcode=1017
  ORA-01017: invalid username/password; logon denied
  
  The log contains:
  
  <SourceReport   card="1"   adapter="DB"   bytes="0"
  adapterreturn="-1005">
     <Message>Failed to connect to the database</Message>
  </SourceReport>
  
  When the 'V' is removed the correct trace file is written
  and (once the account has been unlocked) the connection works,
  the data is retrieved.
  
  -CONNECT orac -USER scott -PASSWORD tiger -T+
  C:\Simple\Database\Test1.dbl
  
  No database trace is produced at all if using the Command Server
  with -TV+.
  

Local fix

• WTXCQ - WTX00048499
  PB / PB
  Circumvention: Remove invalid options from the connection string
  

Problem summary

• Users Affected:
  IBM Transformation Extender DB adapter customers who specify
  invalid adapter command line
  
  Problem Description:
  Invalid options on the database adapter command line get
  incorrectly appended to values associated with the option
  immediately preceding the bad option.
  
  Platforms Affected:
  All
  

Problem conclusion

• Invalid options that appear at the end of a database command
  line are completely ignored.  Before this fix, the invalid
  option would get appended to the value of the previous option.
  For example, if the last valid option was the user id or
  password (e.g. "-password xyz -TV"), the password value would
  get all the content associated with the invalid option (e.g.
  password value assigned to "xyz -TV" versus just "xyz").
  
  Applies to:
  8.3.0.6, 8.4.0.5, 8.4.1.4, 9.0.0.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  check the WebSphere Transformation Extender Downloads page:
  http://www.ibm.com/support/entry/portal/product/other_software/t
  ransformation_extender
  
  If the service pack or product release is available, download it
  from PassportAdvantage:
  http://www.ibm.com/software/howtobuy/passportadvantage/pao_custo
  mers.htm
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a PMR:
  https://www.ibm.com/support/servicerequest/Home.action
  
  Prior to version 9.0.0, IBM Transformation Extender was called
  IBM WebSphere Transformation Extender.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TX COMMAND SERV

• Fixed component ID

  5724M4000

Applicable component levels

• R830 PSY

     UP

• R840 PSY

     UP

• R841 PSY

     UP

• R900 PSY

     UP