Topic
  • 24 replies
  • Latest Post - ‏2006-01-02T11:07:48Z by SystemAdmin
SystemAdmin
SystemAdmin
17917 Posts

Pinned topic DB2 start error: SQL1042C SQLSTATE=58004

‏2005-12-31T08:20:34Z |
I install DB2 V8.2 Personal Edition(windows), but can't start it.
The error displayed is :
DB2: The dependency service or group failed to start

SQL1042C An unexpected system error occured. SQLSTATE=58004

I find that It need NetBIOS Interface service to surpport and my machine doesn't have this service installed. Can anybody tell me how to soulve this problem. Thank you!
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2005-12-31T18:05:25Z  
    Set DB2COMM=TCPIP only.

    hengic@gmail.com wrote:
    > I install DB2 V8.2 Personal Edition(windows), but can't start it.
    > The error displayed is :
    > DB2: The dependency service or group failed to start
    >
    > SQL1042C An unexpected system error occured. SQLSTATE=58004
    >
    > I find that It need NetBIOS Interface service to surpport and my machine doesn't have this service installed. Can anybody tell me how to soulve this problem. Thank you!
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T10:36:35Z  
    Set DB2COMM=TCPIP only.

    hengic@gmail.com wrote:
    > I install DB2 V8.2 Personal Edition(windows), but can't start it.
    > The error displayed is :
    > DB2: The dependency service or group failed to start
    >
    > SQL1042C An unexpected system error occured. SQLSTATE=58004
    >
    > I find that It need NetBIOS Interface service to surpport and my machine doesn't have this service installed. Can anybody tell me how to soulve this problem. Thank you!
    Could you describe in detail. Because I'm a greener of DB2.
    How to set the DB2COMM=TCPIP only
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T12:27:39Z  
    Could you describe in detail. Because I'm a greener of DB2.
    How to set the DB2COMM=TCPIP only
    db2set DB2COMM=TCPIP
    (rtfm)

    <hengic@gmail.com> schreef in bericht
    news:1726680319.1136111828634.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > Could you describe in detail. Because I'm a greener of DB2.
    > How to set the DB2COMM=TCPIP only

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T13:48:25Z  
    db2set DB2COMM=TCPIP
    (rtfm)

    <hengic@gmail.com> schreef in bericht
    news:1726680319.1136111828634.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > Could you describe in detail. Because I'm a greener of DB2.
    > How to set the DB2COMM=TCPIP only

    To expand somewhat, db2set is for DB2 registry variables in which changes
    only take effect an instance start time. So if you change your registry
    settings using db2set, you will need to restart your instance by doing a
    db2stop followed by a db2start.

    >>db2set xxxxxxx=yyyyy
    >>db2stop
    >>db2start

    should do the trick

    Bob

    "Henk" <hwaanders-fool@ed-hotmail.com> wrote in message
    news:dp8hs3$9t3g$1@news.boulder.ibm.com...
    > db2set DB2COMM=TCPIP
    > (rtfm)
    >
    > <hengic@gmail.com> schreef in bericht
    > news:1726680319.1136111828634.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > > Could you describe in detail. Because I'm a greener of DB2.
    > > How to set the DB2COMM=TCPIP only
    >
    >

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T13:53:46Z  
    To expand somewhat, db2set is for DB2 registry variables in which changes
    only take effect an instance start time. So if you change your registry
    settings using db2set, you will need to restart your instance by doing a
    db2stop followed by a db2start.

    >>db2set xxxxxxx=yyyyy
    >>db2stop
    >>db2start

    should do the trick

    Bob

    "Henk" <hwaanders-fool@ed-hotmail.com> wrote in message
    news:dp8hs3$9t3g$1@news.boulder.ibm.com...
    > db2set DB2COMM=TCPIP
    > (rtfm)
    >
    > <hengic@gmail.com> schreef in bericht
    > news:1726680319.1136111828634.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > > Could you describe in detail. Because I'm a greener of DB2.
    > > How to set the DB2COMM=TCPIP only
    >
    >

    Just to add -- if you use the online Information Center at:
    http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp and search on
    db2set, you should be able to find some useful hits at the top of the result
    page of the search.

    Bob

    "Bob IBM" <Bob.At.IBM@gmail.com> wrote in message
    news:dp8mj6$90c2$1@news.boulder.ibm.com...
    > To expand somewhat, db2set is for DB2 registry variables in which changes
    > only take effect an instance start time. So if you change your registry
    > settings using db2set, you will need to restart your instance by doing a
    > db2stop followed by a db2start.
    >
    > >>db2set xxxxxxx=yyyyy
    > >>db2stop
    > >>db2start
    >
    > should do the trick
    >
    > Bob
    >
    > "Henk" <hwaanders-fool@ed-hotmail.com> wrote in message
    > news:dp8hs3$9t3g$1@news.boulder.ibm.com...
    > > db2set DB2COMM=TCPIP
    > > (rtfm)
    > >
    > > <hengic@gmail.com> schreef in bericht
    > > news:1726680319.1136111828634.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > > > Could you describe in detail. Because I'm a greener of DB2.
    > > > How to set the DB2COMM=TCPIP only
    > >
    > >
    >
    >

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T14:24:30Z  
    Just to add -- if you use the online Information Center at:
    http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp and search on
    db2set, you should be able to find some useful hits at the top of the result
    page of the search.

    Bob

    "Bob IBM" <Bob.At.IBM@gmail.com> wrote in message
    news:dp8mj6$90c2$1@news.boulder.ibm.com...
    > To expand somewhat, db2set is for DB2 registry variables in which changes
    > only take effect an instance start time. So if you change your registry
    > settings using db2set, you will need to restart your instance by doing a
    > db2stop followed by a db2start.
    >
    > >>db2set xxxxxxx=yyyyy
    > >>db2stop
    > >>db2start
    >
    > should do the trick
    >
    > Bob
    >
    > "Henk" <hwaanders-fool@ed-hotmail.com> wrote in message
    > news:dp8hs3$9t3g$1@news.boulder.ibm.com...
    > > db2set DB2COMM=TCPIP
    > > (rtfm)
    > >
    > > <hengic@gmail.com> schreef in bericht
    > > news:1726680319.1136111828634.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > > > Could you describe in detail. Because I'm a greener of DB2.
    > > > How to set the DB2COMM=TCPIP only
    > >
    > >
    >
    >

    I have added the environment variable, but it doesn't work.
    The error message displayed is the same as before
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T14:43:46Z  
    I have added the environment variable, but it doesn't work.
    The error message displayed is the same as before
    hengic@gmail.com wrote:
    > I have added the environment variable, but it doesn't work.
    > The error message displayed is the same as before
    Perhaps if you check you Windows Event Viewer to see if any Windows
    services are failing to start.

    Larry Edelstein
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T15:10:03Z  
    hengic@gmail.com wrote:
    > I have added the environment variable, but it doesn't work.
    > The error message displayed is the same as before
    Perhaps if you check you Windows Event Viewer to see if any Windows
    services are failing to start.

    Larry Edelstein
    yes, it depends a service named NetBIOS Interface. However, I don't find this service in the Windows Event Service
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T15:21:27Z  
    yes, it depends a service named NetBIOS Interface. However, I don't find this service in the Windows Event Service
    hengic@gmail.com wrote:

    > yes, it depends a service named NetBIOS Interface. However, I don't find this service in the Windows Event Service
    So your Windows Event Monitor shows that this service fails to start at
    the exact time that you are trying to start DB2? Hmmm. I have nothing
    called Netbios Interface in my windows services and my DB2 works fine.
    Not sure what is happening. You may need to open up a PMR with IBM support.

    Larry Edelstein
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T15:25:02Z  
    yes, it depends a service named NetBIOS Interface. However, I don't find this service in the Windows Event Service
    Let's see what your registry has... could you please post the output from
    "db2set -all"?

    Also, do you have any NetBIOS remote nodes defined? "db2 list node
    directory"

    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:1742688109.1136128275843.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > yes, it depends a service named NetBIOS Interface. However, I don't find
    > this service in the Windows Event Service

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T15:27:34Z  
    hengic@gmail.com wrote:

    > yes, it depends a service named NetBIOS Interface. However, I don't find this service in the Windows Event Service
    So your Windows Event Monitor shows that this service fails to start at
    the exact time that you are trying to start DB2? Hmmm. I have nothing
    called Netbios Interface in my windows services and my DB2 works fine.
    Not sure what is happening. You may need to open up a PMR with IBM support.

    Larry Edelstein
    > So your Windows Event Monitor shows that this service fails to start at
    > the exact time that you are trying to start DB2?

    My interpretation is that the service does not exist (same as you). As a
    result of that, DB2 is not starting.

    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    "Larry" <lsedels@nospam.net> wrote in message
    news:dp8s1l$a5vu$1@news.boulder.ibm.com...
    > hengic@gmail.com wrote:
    >
    >> yes, it depends a service named NetBIOS Interface. However, I don't find
    >> this service in the Windows Event Service
    > So your Windows Event Monitor shows that this service fails to start at
    > the exact time that you are trying to start DB2? Hmmm. I have nothing
    > called Netbios Interface in my windows services and my DB2 works fine. Not
    > sure what is happening. You may need to open up a PMR with IBM support.
    >
    > Larry Edelstein

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T15:44:29Z  
    Let's see what your registry has... could you please post the output from
    "db2set -all"?

    Also, do you have any NetBIOS remote nodes defined? "db2 list node
    directory"

    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:1742688109.1136128275843.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > yes, it depends a service named NetBIOS Interface. However, I don't find
    > this service in the Windows Event Service

    [e] DB2PATH=C:\Program Files\IBM\SQLLIB\
    [i] DB2INSTPROF=C:\Program Files\IBM\SQLLIB
    [i] DB2COMM=TCPIP
    [g] DB2_EXTSECURITY=YES
    [g] DB2SYSTEM=BLRKEC54067D
    [g] DB2PATH=C:\Program Files\IBM\SQLLIB\
    [g] DB2INSTDEF=DB2
    [g] DB2ADMINSERVER=DB2DAS00
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T15:53:39Z  
    hengic@gmail.com wrote:

    > yes, it depends a service named NetBIOS Interface. However, I don't find this service in the Windows Event Service
    So your Windows Event Monitor shows that this service fails to start at
    the exact time that you are trying to start DB2? Hmmm. I have nothing
    called Netbios Interface in my windows services and my DB2 works fine.
    Not sure what is happening. You may need to open up a PMR with IBM support.

    Larry Edelstein
    Before starting DB2, should I start the service of DB2-DB2 in the Windows Event Monitor. I try to start it. It display an error saying :
    Could not start the DB2-DB2 service on Local Computer.
    Error 1068: The dependency service or group failed to start.

    And I check the services needed in the Dependencies tab. There is a NetBIOSGroup, NetBIOS Interface. So I suppose that it need to start NetBIOS Interface service first. But I don't find this entry in the Windows Event Monitor.
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T16:01:40Z  
    Let's see what your registry has... could you please post the output from
    "db2set -all"?

    Also, do you have any NetBIOS remote nodes defined? "db2 list node
    directory"

    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:1742688109.1136128275843.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > yes, it depends a service named NetBIOS Interface. However, I don't find
    > this service in the Windows Event Service

    How to check it?
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T16:33:36Z  
    Before starting DB2, should I start the service of DB2-DB2 in the Windows Event Monitor. I try to start it. It display an error saying :
    Could not start the DB2-DB2 service on Local Computer.
    Error 1068: The dependency service or group failed to start.

    And I check the services needed in the Dependencies tab. There is a NetBIOSGroup, NetBIOS Interface. So I suppose that it need to start NetBIOS Interface service first. But I don't find this entry in the Windows Event Monitor.
    NetBIOS is not a 'Service' in the Windows sense. It's a network
    protocol, usually used under the covers wrapped inside a TCP/IP wrapper.

    Go into your Network Connection properties (Control Panel, Network
    Connections, right-click on your active connection and select Properties).
    Edit the properties of "Internet Protocol (TCP/IP)", and click on
    "Advanced", then go to the "WINS" tab of that notebook. On my system,
    NetBIOS is enabled ("Default" selected).

    If that doesn't fix it, I'm out of guesses.
    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:359910569.1136130850312.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > Before starting DB2, should I start the service of DB2-DB2 in the Windows
    > Event Monitor. I try to start it. It display an error saying :
    > Could not start the DB2-DB2 service on Local Computer.
    > Error 1068: The dependency service or group failed to start.
    >
    > And I check the services needed in the Dependencies tab. There is a
    > NetBIOSGroup, NetBIOS Interface. So I suppose that it need to start
    > NetBIOS Interface service first. But I don't find this entry in the
    > Windows Event Monitor.

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T17:05:09Z  
    NetBIOS is not a 'Service' in the Windows sense. It's a network
    protocol, usually used under the covers wrapped inside a TCP/IP wrapper.

    Go into your Network Connection properties (Control Panel, Network
    Connections, right-click on your active connection and select Properties).
    Edit the properties of "Internet Protocol (TCP/IP)", and click on
    "Advanced", then go to the "WINS" tab of that notebook. On my system,
    NetBIOS is enabled ("Default" selected).

    If that doesn't fix it, I'm out of guesses.
    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:359910569.1136130850312.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > Before starting DB2, should I start the service of DB2-DB2 in the Windows
    > Event Monitor. I try to start it. It display an error saying :
    > Could not start the DB2-DB2 service on Local Computer.
    > Error 1068: The dependency service or group failed to start.
    >
    > And I check the services needed in the Dependencies tab. There is a
    > NetBIOSGroup, NetBIOS Interface. So I suppose that it need to start
    > NetBIOS Interface service first. But I don't find this entry in the
    > Windows Event Monitor.

    The configuration is also the same as your description.
    But it doesn't work.
    Thank you all the same, Larry Menard
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-01T17:16:15Z  
    The configuration is also the same as your description.
    But it doesn't work.
    Thank you all the same, Larry Menard
    One more guess...

    Do a "db2 get dbm cfg" and look for the line:

    NetBIOS Workstation name (NNAME) =

    If there is any value beside "(NNAME) = ", remove it by issuing the
    following command:

    db2 update dbm cfg using nname ''

    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:411668332.1136135175460.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > The configuration is also the same as your description.
    > But it doesn't work.
    > Thank you all the same, Larry Menard

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-02T03:37:08Z  
    Before starting DB2, should I start the service of DB2-DB2 in the Windows Event Monitor. I try to start it. It display an error saying :
    Could not start the DB2-DB2 service on Local Computer.
    Error 1068: The dependency service or group failed to start.

    And I check the services needed in the Dependencies tab. There is a NetBIOSGroup, NetBIOS Interface. So I suppose that it need to start NetBIOS Interface service first. But I don't find this entry in the Windows Event Monitor.
    What Windows platform are you running on (XP Home/Professional, NT, Windows 98, Server 2003, MS Cluster)?

    nntp://news.software.ibm.com/ibm.software.db2.udb/<359910569.1136130850312.JavaMail.wassrvr@ltsgwas007.sby.ibm.com>

    Before starting DB2, should I start the service of DB2-DB2 in the Windows Event Monitor. I try to start it. It display an error saying :
    Could not start the DB2-DB2 service on Local Computer.
    Error 1068: The dependency service or group failed to start.

    And I check the services needed in the Dependencies tab. There is a NetBIOSGroup, NetBIOS Interface. So I suppose that it need to start NetBIOS Interface service first. But I don't find this entry in the Windows Event Monitor.
    http://ibm.software.db2.udb

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-02T06:16:00Z  
    One more guess...

    Do a "db2 get dbm cfg" and look for the line:

    NetBIOS Workstation name (NNAME) =

    If there is any value beside "(NNAME) = ", remove it by issuing the
    following command:

    db2 update dbm cfg using nname ''

    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:411668332.1136135175460.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > The configuration is also the same as your description.
    > But it doesn't work.
    > Thank you all the same, Larry Menard

    Is it a db2 command?
    I type it in the command window.
    It displays an error:
    DB21061E uninitialize command line environment

    By the way, it gives an error message saying can't add contact information when installing the DB2.
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-02T06:19:46Z  
    What Windows platform are you running on (XP Home/Professional, NT, Windows 98, Server 2003, MS Cluster)?

    nntp://news.software.ibm.com/ibm.software.db2.udb/<359910569.1136130850312.JavaMail.wassrvr@ltsgwas007.sby.ibm.com>

    Before starting DB2, should I start the service of DB2-DB2 in the Windows Event Monitor. I try to start it. It display an error saying :
    Could not start the DB2-DB2 service on Local Computer.
    Error 1068: The dependency service or group failed to start.

    And I check the services needed in the Dependencies tab. There is a NetBIOSGroup, NetBIOS Interface. So I suppose that it need to start NetBIOS Interface service first. But I don't find this entry in the Windows Event Monitor.
    http://ibm.software.db2.udb

    Windows XP Professional
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-02T06:23:00Z  
    Is it a db2 command?
    I type it in the command window.
    It displays an error:
    DB21061E uninitialize command line environment

    By the way, it gives an error message saying can't add contact information when installing the DB2.
    On Windows, DB2 commands cannot be entered from a normal command window.
    You need to open a DB2 CLP Window and run DB2 commands in there.

    I ignore the warnings about adding contact information, it is important
    only if you use the notification capability of DB2.
    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:1227968291.1136182591051.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > Is it a db2 command?
    > I type it in the command window.
    > It displays an error:
    > DB21061E uninitialize command line environment
    >
    > By the way, it gives an error message saying can't add contact information
    > when installing the DB2.

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-02T09:01:30Z  
    On Windows, DB2 commands cannot be entered from a normal command window.
    You need to open a DB2 CLP Window and run DB2 commands in there.

    I ignore the warnings about adding contact information, it is important
    only if you use the notification capability of DB2.
    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:1227968291.1136182591051.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > Is it a db2 command?
    > I type it in the command window.
    > It displays an error:
    > DB21061E uninitialize command line environment
    >
    > By the way, it gives an error message saying can't add contact information
    > when installing the DB2.

    NO, NNAME is null
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-02T10:14:35Z  
    What Windows platform are you running on (XP Home/Professional, NT, Windows 98, Server 2003, MS Cluster)?

    nntp://news.software.ibm.com/ibm.software.db2.udb/<359910569.1136130850312.JavaMail.wassrvr@ltsgwas007.sby.ibm.com>

    Before starting DB2, should I start the service of DB2-DB2 in the Windows Event Monitor. I try to start it. It display an error saying :
    Could not start the DB2-DB2 service on Local Computer.
    Error 1068: The dependency service or group failed to start.

    And I check the services needed in the Dependencies tab. There is a NetBIOSGroup, NetBIOS Interface. So I suppose that it need to start NetBIOS Interface service first. But I don't find this entry in the Windows Event Monitor.
    http://ibm.software.db2.udb

    This may not be a UDB problem.

    Yes there is a dependency of NetBios for the UDB Instance to start. Please check that NetBIOS over TCP/IP (NetBT) is enabled within XP - google "netbios interface windows xp" will give you a good start, including enabling via network - tcpip - advanced - wins - Enable netbios, and TCP/IP NetBIOS Helper service….

    Regards,

    Neil.

    nntp://news.software.ibm.com/ibm.software.db2.udb/<dpa754$67qe$1@news.boulder.ibm.com>

    What Windows platform are you running on (XP Home/Professional, NT, Windows 98, Server 2003, MS Cluster)?

    nntp://news.software.ibm.com/ibm.software.db2.udb/<359910569.1136130850312.JavaMail.wassrvr@ltsgwas007.sby.ibm.com>

    Before starting DB2, should I start the service of DB2-DB2 in the Windows Event Monitor. I try to start it. It display an error saying :
    Could not start the DB2-DB2 service on Local Computer.
    Error 1068: The dependency service or group failed to start.

    And I check the services needed in the Dependencies tab. There is a NetBIOSGroup, NetBIOS Interface. So I suppose that it need to start NetBIOS Interface service first. But I don't find this entry in the Windows Event Monitor.
    http://ibm.software.db2.udb
    http://ibm.software.db2.udb

  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: DB2 start error: SQL1042C SQLSTATE=58004

    ‏2006-01-02T11:07:48Z  
    On Windows, DB2 commands cannot be entered from a normal command window.
    You need to open a DB2 CLP Window and run DB2 commands in there.

    I ignore the warnings about adding contact information, it is important
    only if you use the notification capability of DB2.
    --
    Larry Menard
    "Defender of Geese and of All Things Natural"
    <hengic@gmail.com> wrote in message
    news:1227968291.1136182591051.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
    > Is it a db2 command?
    > I type it in the command window.
    > It displays an error:
    > DB21061E uninitialize command line environment
    >
    > By the way, it gives an error message saying can't add contact information
    > when installing the DB2.

    I solved the problem.
    I found a service named server disabled at last.
    It works after starting this service.
    Thank you very much, all guys helping me.