SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 04:38 PM
| ||||
| ||||
 Starting DB2 Universal 8.1 I've been struggling trying to start DB2 8.1 on my Windows XP workstation. Supposedly I have to enable JDBC before starting DB2 running usejdbc2.bat script, but I can't find it anywhere on C: drive. I assume that JDBC was installed when I installed DB2 8.1. I can see that db2jcc.jar and sqlj.zip files were added to the system CLASSPATH and that db2jcct2.dll has been installed in the sqllib\bin directory, but I cannot find the folder /java12 where the usejdbc2.bat is supposed to be. I also try to start DB2 with db2start and I get the message "SQL1397N The DB2 service failed to logon". Am I getting this mesage because I have not enabled JDBC or is it a separate issue? I will appreciate any help I can get. Thanks, Luis Molina      |
|
02-26-2008, 04:38 PM
| |||
| |||
| Re: Starting DB2 Universal 8.1 Luis, There is no more "java12" directory in DB2 V8. In DB2 V8, all JDBC is 2.0. The SQL1379 is a separate issue. Check the properties of the Windows "service" for your DB2 Instance, verify that it is using a valid user account and password. -- Larry Menard IBM Workstation Database (DB2) Information Development, Samples Coordinator Defender of Geese and of All Things Natural "Lou" <lamrend43@yahoo.com> wrote in message news:b44ce593.0401161212.3150cc6d@posting.google.c om... > I've been struggling trying to start DB2 8.1 on my Windows XP > workstation. Supposedly I have to enable JDBC before starting DB2 > running usejdbc2.bat script, but I can't find it anywhere on C: drive. > I assume that JDBC was installed when I installed DB2 8.1. I can see > that db2jcc.jar and sqlj.zip files were added to the system CLASSPATH > and that db2jcct2.dll has been installed in the sqllib\bin directory, > but I cannot find the folder /java12 where the usejdbc2.bat is > supposed to be. I also try to start DB2 with db2start and I get the > message "SQL1397N The DB2 service failed to logon". Am I getting this > mesage because I have not enabled JDBC or is it a separate issue? > > I will appreciate any help I can get. > > Thanks, > > Luis Molina |
|
02-26-2008, 04:41 PM
| |||
| |||
| Re: Starting DB2 Universal 8.1 Jan. 20th, 2004 Larry, How do I check that Windows service for my DB2 instance? I opened a Control Center window but didn't see that option for the DB2 instance. Also, how do I enable JDBC without the usejdbc2.bat script file? Is there a substitute for that? Thanks for your help. Luis "Larry Menard" <lmenard@GoSpamYourself.com> wrote in message news:<bu9p7l$a1l$1@hanover.torolab.ibm.com>... > Luis, > > There is no more "java12" directory in DB2 V8. In DB2 V8, all JDBC is > 2.0. > > The SQL1379 is a separate issue. Check the properties of the Windows > "service" for your DB2 Instance, verify that it is using a valid user > account and password. > -- > Larry Menard > IBM Workstation Database (DB2) Information Development, Samples Coordinator > Defender of Geese and of All Things Natural > > > "Lou" <lamrend43@yahoo.com> wrote in message > news:b44ce593.0401161212.3150cc6d@posting.google.c om... > > I've been struggling trying to start DB2 8.1 on my Windows XP > > workstation. Supposedly I have to enable JDBC before starting DB2 > > running usejdbc2.bat script, but I can't find it anywhere on C: drive. > > I assume that JDBC was installed when I installed DB2 8.1. I can see > > that db2jcc.jar and sqlj.zip files were added to the system CLASSPATH > > and that db2jcct2.dll has been installed in the sqllib\bin directory, > > but I cannot find the folder /java12 where the usejdbc2.bat is > > supposed to be. I also try to start DB2 with db2start and I get the > > message "SQL1397N The DB2 service failed to logon". Am I getting this > > mesage because I have not enabled JDBC or is it a separate issue? > > > > I will appreciate any help I can get. > > > > Thanks, > > > > Luis Molina |
|
02-26-2008, 04:41 PM
| ||||
| ||||
| Re: Starting DB2 Universal 8.1 Luis, From a command window type "services.msc". This will bring up the "Services" MMC plugin. From there you should see your DB2* services and will need to verify(/update) the "Log On As" account is valid. You don't keed to do anything to get JDBC 2.0 in v8, it's the default. -- Garfield A. Lewis DB2 UDB Development, IBM Canada Laboratory "Lou" <lamrend43@yahoo.com> wrote in message news:b44ce593.0401200838.5789713c@posting.google.c om... > Jan. 20th, 2004 > > Larry, > > How do I check that Windows service for my DB2 instance? I opened a > Control Center window but didn't see that option for the DB2 instance. > Also, how do I enable JDBC without the usejdbc2.bat script file? Is > there a substitute for that? > > Thanks for your help. > > > Luis > > > "Larry Menard" <lmenard@GoSpamYourself.com> wrote in message news:<bu9p7l$a1l$1@hanover.torolab.ibm.com>... > > Luis, > > > > There is no more "java12" directory in DB2 V8. In DB2 V8, all JDBC is > > 2.0. > > > > The SQL1379 is a separate issue. Check the properties of the Windows > > "service" for your DB2 Instance, verify that it is using a valid user > > account and password. > > -- > > Larry Menard > > IBM Workstation Database (DB2) Information Development, Samples Coordinator > > Defender of Geese and of All Things Natural > > > > > > "Lou" <lamrend43@yahoo.com> wrote in message > > news:b44ce593.0401161212.3150cc6d@posting.google.c om... > > > I've been struggling trying to start DB2 8.1 on my Windows XP > > > workstation. Supposedly I have to enable JDBC before starting DB2 > > > running usejdbc2.bat script, but I can't find it anywhere on C: drive. > > > I assume that JDBC was installed when I installed DB2 8.1. I can see > > > that db2jcc.jar and sqlj.zip files were added to the system CLASSPATH > > > and that db2jcct2.dll has been installed in the sqllib\bin directory, > > > but I cannot find the folder /java12 where the usejdbc2.bat is > > > supposed to be. I also try to start DB2 with db2start and I get the > > > message "SQL1397N The DB2 service failed to logon". Am I getting this > > > mesage because I have not enabled JDBC or is it a separate issue? > > > > > > I will appreciate any help I can get. > > > > > > Thanks, > > > > > > Luis Molina |
Linear Mode
