| Author |
Message
|
| jk |
 Posted: Wed Mar 26, 2003 10:00 pm Post subject: FMC24300E Connect to DB failed |
 |
|
Apprentice
Joined: 09 Jan 2002
Posts: 36
|
I'm having AIX4.3.3, MQWF 3.3.2 and DB2 7.2.6.
1) i have logged in as user fmc. when i try to import an fdl using "fmcibie -i case2.fdl -u ADMIN -p password -ot", i get the following error.
FMC24500I fmcibie is starting.
FMC24300E Connect to DB failed.
FMC24560I fmcibie finished and found 1 errors 0 warnings. RC = 20
the user fmc has db2iadm1, mqm and fmcgrp as the groups as well as the administrative groups. y then am i unable to connect to the db?
2) if i log on to the db using fmc i get sql1404n password expired?
suggestions welcome. thanx |
|
| Back to top |
|
 |
| amittalekar |
| Posted: Thu Mar 27, 2003 3:00 pm Post subject: |
|
|
Disciple
Joined: 03 Apr 2002
Posts: 166
Location: VA, USA
|
| That mean An error occurred while trying to access the database. Please use fmczchk utility to check ur configuration. Also check the system and err logs |
|
| Back to top |
|
|
| jk |
| Posted: Thu Mar 27, 2003 9:52 pm Post subject: |
|
|
Apprentice
Joined: 09 Jan 2002
Posts: 36
|
when i run fmczchk i get the following msg.
FMC34534E: DB2INSTANCE is incorrect or not set.
but i'm able to connect to the db from the db2 prompt with user db2inst1.
this was when i had the default configuration installed.
i deleted the FMC configuration and recreated the same. while recreating and accessing the existing runtime db, it gives me the following error
SQL1404 password expired.
In addition there are these errors while running fmczchk
FMC34013I: ===> Java Agent found, checks started.
Unable to dlopen libjava.a: A file or directory in the path name does not exist.
FMC34016E: System call failed: JNI_GetDefaultJavaVMInitArgs() returned -1.
FMC34013I: ===> Java API found, checks started.
Unable to dlopen libjava.a: A file or directory in the path name does not exist.
FMC34016E: System call failed: JNI_GetDefaultJavaVMInitArgs() returned -1.
i have given full rights(read/ write/execute) to the file libjava.a in the :/usr/java131/jre/bin folder, but it is of no use.
the PATH variable has
# echo $PATH
/usr/java131/bin:/usr/java131/jre/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/dt/bin:/usr/bin/X11:/sbin
the CLASSPATH variable has
# echo $CLASSPATH
/usr/lpp/fmc/bin/fmcoutil.jar
thanx |
|
| Back to top |
|
|
| amittalekar |
| Posted: Fri Mar 28, 2003 6:16 am Post subject: |
|
|
Disciple
Joined: 03 Apr 2002
Posts: 166
Location: VA, USA
|
I have no experience on AIX.. but done same thing on solaris...
verify whether db2 passwd is really expired or not....restart db2 once...
and for other 2 errors check whether u have exported tha path & classpath |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Mar 28, 2003 6:29 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
JK:
Have a look at the install guide, and there is some guidance as to the commands you must issue to get the instance cataloged etc. I too, have no UNIX exprerience, but I have done this on Windows using the info in the Install guide.
GOOD LUCK
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| vennela |
| Posted: Fri Mar 28, 2003 7:06 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
1. While creating the configuration with a Java agaent component you will have to specify the Java/JDK installed directory ( Entering information for the Java Agent section of chapter  . If you give the right directory mostly you will not get those java errors. You should be having this information in the fmcrc file. (/var/fmc/cfgs/FMC directory).
2. You DB error:
Why don't you try this. Login as DB2INST1 and run the fmcibie. May be fmcibie is not in the PATH of db2inst1, give the absolute complete path for the fmcibie executable and try to import the FDL.
(I have never did this but it may work)
As to your fmc's password expiry:
just in case if you haven't seen this
| Code: |
db2 => ? sql1404n
SQL1404N Password expired.
Explanation: Your password has expired.
User Response: Change your password, then retry the request
using the new password. You can use the DB2 Client Configuration
Assistant, or Command Line Processor CONNECT and ATTACH commands
to change your password.
sqlcode: -1404
sqlstate: 08004
db2 =>
|
-------
Venny |
|
| Back to top |
|
|
| manoj |
| Posted: Fri Mar 28, 2003 10:32 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
Possible reason is you don't 've the .db2profile in u r workflow users's
.profile (in SUN box , i dono what's corresponding for AIX).
One more point is in SUN box if u login as a Super user say "root" and from the root's login shell if u try to login as "fmc" user then the login profile for "fmc" will not be executed. correlate this in AIX.
_________________
-manoj |
|
| Back to top |
|
|
| jk |
| Posted: Mon Mar 31, 2003 5:56 am Post subject: |
|
|
Apprentice
Joined: 09 Jan 2002
Posts: 36
|
the SQL1404 password expired was handled by logging into the aix system using the fmc id. then i ran the . /home/db2inst1/sqllib/db2profile
the path has
$ echo $PATH
/usr/java131/bin:/usr/java131/jre/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/dt/bin:/usr/bin/X11:/sbin
and the classpath has
$ echo $CLASSPATH
/usr/lpp/fmc/bin/fmcoutil.jar
i have selected local bindings for the Java Agent , during the configuration i have selected the path of the jdk/jre installation as /usr/java131/jre
what else has to go into the path/classpath to remove the following errors? i have logged into the sytem itself as fmc.
FMC34013I: ===> Java Agent found, checks started.
Unable to dlopen libjava.a: A file or directory in the path name does not exist.
FMC34016E: System call failed: JNI_GetDefaultJavaVMInitArgs() returned -1.
FMC34013I: ===> Java API found, checks started.
Unable to dlopen libjava.a: A file or directory in the path name does not exist.
FMC34016E: System call failed: JNI_GetDefaultJavaVMInitArgs() returned -1.
FMC34019E: Cannot open file '/fmczchk.log' for writing.
FMC34999I: Configuration checker ended: 3 error(s), 0 warning(s), rc = 0. |
|
| Back to top |
|
|
|
|
