IFS

Oracle JDE EnterpriseOne and MTXW HELL!

button print grnw20 Oracle JDE EnterpriseOne and MTXW HELL!

Ok, so this has come up before, but it’s been awhile and I totally forgot about it.

After an update package deployment, when a user tried to login many of the iSeries jobs went in to a MTXW (mutex wait) state.  So, we bounced services.  Nothing.  Then, we brought all services down and deleted all SQLPKGs (SQL Packages) that were owned by ONEWORLD.  Nothing.  Then, after much frustration I deleted the following files from the IFS system:

  • dddict.ddb
  • dddict.xdb
  • ddtext.ddb
  • ddtext.xdb
  • glbltbl.ddb
  • glbltbl.xdb

 

These files get re-generated on-the-fly.

What ever was corrupt was in these files.


Users Are Unable To Map A Drive To The IFS On An IBM iSeries

button print grnw20 Users Are Unable To Map A Drive To The IFS On An IBM iSeries

Every once in a while, we encounter users that are unable to map a drive to the IFS.  We do the normal troubleshooting:

  • Does the user have permissions to the IFS directory and share
  • Is the IFS shared out correctly
  • Is the User Profile disabled

 

After completing those basic reviews, everything looks as though the user should have no problem, however they are still unable to map the drive to the IFS.

Unfortunately (well as far as I know anyway), there is another place to look… the iSeries NetServer disabled UserIDs.  The images below explain how to access a list of User Profiles that the system has disabled from accessing system resources over TCP/IP using iSeries Navigator.

  1. Connect to your server through iSeries Navigator
  2. Expand Network
  3. Expand Servers
  4. Select TCP/IP
  5. Right-Click iSeries NetServer
  6. Select the UserIDs that you would like to re-enable
  7. Click the [Enable User ID] button

 

image thumb Users Are Unable To Map A Drive To The IFS On An IBM iSeries

image thumb1 Users Are Unable To Map A Drive To The IFS On An IBM iSeries


End Of Line (EOL) Character Encoding Using CP1252 and B34A1010

button print grnw20 End Of Line (EOL) Character Encoding Using CP1252 and B34A1010

If using encoding CP1252 (ASCII), the EOL character is only LineFeed (hex 0A) and therefore, the flat file transferred during FTP also contains LineFeed. If the EOL characters Carriage Return (hex 0D) and LineFeed (hex 0A) are required in the flat file, use encoding IBM-37 instead and the FTP download from the AS/400 to the PC should be in non-Binary mode.
Following describes how to view flat file data on the AS/400 and on the PC to understand the EOL characters :

  • On the AS/400, key in command WRKLNK to view the output flat file in Hex mode as follows, assuming flat file TEXT01.txt is in IFS directory /DV810/EXPORT :-
    • Key in command WRKLNK ‘/DV810/EXPORT/TEXT01.txt. Take option 5 to browse the data
    • Once in the Browse: /DV810/EXPORT/TEXT01.TXT screen, press F10 to display the data in Hex Mode (see below), the actual data in the file starts after the first row, every 2 hex characters make up the actual character. For CP1252 (ASCII) encoding, 61=a, 58=X, 0A=LineFeed etc.
    • For IBM-37 (EBCDIC) encoding, 81=a, E7=X, 0D=CarriageReturn, 25=LineFeed.
    • For the ASCII-EBCDIC chart, download from http://natural-innovations.com/computing/asciiebcdic.html.
Browse : /DV810/EXPORT/TEXT01.TXT  (CP1252 – ASCII)                                              
Record :       1   of       2 by  14            Column :    1     59 by  19     
Control :                                                                           
- – - -  + – - -  – * – -  – - + -  – - – *    —-+—-*—-+—-*       
405C5C5C 5C5C5C5C 5C5C5C5C 5CC28587 89959589    ************Beginni       
6162630A                                                                     abc       
58595A0A                                                                     XYZ       
405C5C5C 5C5C5C5C 5C5C5C5C 5CC59584 40968640    ************End of  

    • Each data row is appended by either 1 or 2 dots (.), focus on each dot and the dot will focus on the corresponding hex code – 0d (carriage return), 0a (linefeed).

via Oracle


Find EnterpriseOne (E1) Tools Release Version On IBM iSeries AS400

button print grnw20 Find EnterpriseOne (E1) Tools Release Version On IBM iSeries AS400

Use the command below to determine the Tools Release version that has been installed on the IBM iSeries AS400:

DSPF FILE(E900SYS/LOG) – JDE EnterpriseOne 9.0 installations
DSPF FILE(E811SYS/LOG) – JDE EnterpriseOne 8.11 installations


Windows Vista / Windows 7 & IBM iSeries IFS Mapped Drive

button print grnw20 Windows Vista / Windows 7 & IBM iSeries IFS Mapped Drive

If you are using Windows Vista or Windows 7 and need to map a drive to an iSeries IFS directory you will need to follow the steps below:

  1. Open the Local Security Policy editor: Start – Run – “secpopl.msc” – Ok
    image thumb Windows Vista / Windows 7 & IBM iSeries IFS Mapped Drive
  2. If a User Account Control window appears, click [Continue].
  3. Expand Local Policies – Security Options
    image thumb1 Windows Vista / Windows 7 & IBM iSeries IFS Mapped Drive
  4. Double-click  “Network security: LAN Manager authentication level”
  5. Change the value to “Send LM & NTLM – use NTLMv2 session security if negotiated”
    image thumb2 Windows Vista / Windows 7 & IBM iSeries IFS Mapped Drive

 

 

This is documented on IBM’s website: http://www-01.ibm.com/support/docview.wss?uid=nas2bb4cf3cc6d1a859e862573900041ed36.

Another install-related issue concerns installing from the     
applied System i PTF.  Once the PTF is applied, you can install
this service pack or complete merged image from the network   
share called QIBM on your System i.  Accessing this share uses 
the LAN Manager component of Windows, and NetServer support   
on the System i.  In Windows Vista, Microsoft has changed the 
default negotiation method for such connections, so that, at   
this time, accessing shares on the System i may fail. One way 
to work around this problem is to change a policy setting on   
the PC.  This action requires administrator authority, and can 
be performed as follows:                                       
  1) Click Start, click All Programs, click Accessories, click 
     Run; then type "secpol.msc" (without the quotes) in the   
     Open text box, and click OK.                             
  2) If a User Account Control dialog box appears. verify that 
     the details shown match the request you initiated (you are
     starting the Microsoft Management Console), and if so,   
     click Continue.                                           
  3) From the Local Security Settings console tree, expand     
     Local Policies, then click Security Options.             
  4) In the right pane, scroll down to the setting called     
     "Network security: LAN Manager authentication level       
     Properties" and double-click it.                         
  5) Note the current value.  The default value at the time of 
     this writing is "Send NTLMv2 response only".  If the value
     is not as follows, change it to be:                       
     "Send LM & NTLM-use NTLMv2 session security if negotiated"
     then click OK, and exit the Local Security Settings       
     console. You should now be able to access network shares 
     on the System i.                                         
The last issue related to install has to do with installing   
from a network share.  Testing has shown that, in some cases, 
installing System i Access for Windows on a Windows Vista PC   
from a network share fails.  In such cases, copying the files 
from the network share to the PC’s local hard disk, then       
re-starting the installation from the local hard disk,         
completes successfully.                                       
Alternatively, you can map a drive to the network share in a   
Command Prompt box that was opened as administrator and start 
the installation from the mapped drive.                       
To open a Command Prompt box as administrator, click Start,   
then All Programs then Accessories, right-click the Command   
Prompt icon and choose Run as administrator. This action will 
prompt you to allow the Command Prompt program to run elevated.
At the Command Prompt, type in the following command to map the
network drive:                                                 
  net use X: \server_nameshare_name                         
where X: is the drive you want to map, server_name is the     
network server’s name and share_name is the name of the shared 
directory. If you are installing from a System i, you would   
type in                                                       
  net use X: \system_i_nameQIBM                             
Then change to the mapped drive in your Command Prompt box and 
run the setup program from there. If you are mapping a drive   
to the QIBM share of your System i, these are the steps you   
should follow for a 32-bit installation of System i Access     
for Windows V6R1:                                             
  X:                                                           
  cd ProdDataAccessWindowsImage32                           
  setup.exe                                                   
If you are installing on AMD64 or on Itanium hardware use     
Image64a or Image64i instead.                                 
The cause of this failure is being investigated.


  • E1Tips Job List

  • Directory Membership

  • Copyright © 1996-2010 E1 Tips. All rights reserved.
    iDream theme by Templates Next | Powered by WordPress