on ‎2010 Mar 23 9:41 AM
Hello,
I have my SAP installed and running fine. In Control Centre I try to add "New System" and try to "Discover". Its failing saying "CCA1003I No DB2 system was found on the network."
I thought this is because DAS is not Present. I try to create it using
C:\Users\db2sep> db2admin create
SQL1042C An unexpected system error occurred.
Can you please help here... I want to add the System using Discover, otherwise we face a lot of errors if we do it manualy.
Thanks,
Request clarification before answering.
Hi,
to ensure their is no DAS already, try running command
db2admin start
what is the result?
The SQL error does not give us much information, are there any errors logged in the db2diag from the time of this command?
If not, try tracing as follows:
1. db2diag -A
2. db2trc on -f trace.dmp
3. db2admin create <<< this command will fail with SQL1042C I presume
4. db2trc off
5. db2trc flw trace.dmp trace.flw
6. db2trc fmt trace.dmp trace.fmt
Please update us with the trace.flw , trace.fmt , db2diag.log and command line
output.
regards,
Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Paul,
Here are the Results,
db2admin start
SQL4404N The DB2 Administration Server does not exist.
1. db2diag -A - No entries in db2diag.log
2. db2trc on -f trace.dmp
Trace could not allocate the necessary IPC resources. Please retry
using a smaller buffer size.
Thanks..
Now, I need to create DAS somehow.. db2admin create gives error.
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 6 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.