How to solve SQL1009N - DB2 Database

James

Please ran the following commands as below. (databae is V8 fix 11 on
AIX)
1.db2 connect to DBNAME user db2inst3 using XXX
2.db2 get db cfg
Then receive an error: SQL1009N The command is not valid.

I can run "db2 list tables". What I concern is why I can not run "get
db cfg" command? I checked the database directory, that's ok. I found
the database was in inconsistent status when I ran db2dart tool.

Any advice?

Thank you so much!

James

Dec 22 '06 #1

Subscribe Post Reply

3039

Pierre Saint-Jacques

The command should be
db2 get db cfg for DBNAME
Do following, for this or any other message:
db2 ? sql1009n

D:\SQLLIB\BIN>db2 ? sql1009n
SQL1009N The command is not valid.

Explanation:

The command is not supported when issued on a client-only
workstation or against remote databases. An example of such a
command is cataloging a local database.

The command cannot be processed.

User Response:

Possible solutions include:

o Issue the specified command from a non client-only
workstation or from the workstation where the database
resides.

o Verify that the database is cataloged correctly.

o Issue a different command.

Regards, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"James" <hu*****@gmail.coma écrit dans le message de news:
11**********************@80g2000cwy.googlegroups.c om...

Please ran the following commands as below. (databae is V8 fix 11 on
AIX)
1.db2 connect to DBNAME user db2inst3 using XXX
2.db2 get db cfg
Then receive an error: SQL1009N The command is not valid.

I can run "db2 list tables". What I concern is why I can not run "get
db cfg" command? I checked the database directory, that's ok. I found
the database was in inconsistent status when I ran db2dart tool.

Any advice?

Thank you so much!

James

Dec 22 '06 #2

James

Thanks.
1.When I connect to database, I can run "get db cfg" directly, need not
run "get db cfg for xxx"
2.I knew the meaning of SQL1009N. My question is why I can connect to
database and perform import, export and SQL statements and so on, just
failed on command "get db cfg" or "get db cfg for xxx". Just due to
catalog issue?
On Dec 22, 12:06 pm, "Pierre Saint-Jacques" <sesc...@invalid.net>
wrote:

The command should be
db2 get db cfg for DBNAME
Do following, for this or any other message:
db2 ? sql1009n

D:\SQLLIB\BIN>db2 ? sql1009n

SQL1009N The command is not valid.

Explanation:

The command is not supported when issued on a client-only
workstation or against remote databases. An example of such a
command is cataloging a local database.

The command cannot be processed.

User Response:

Possible solutions include:

o Issue the specified command from a non client-only
workstation or from the workstation where the database
resides.

o Verify that the database is cataloged correctly.

o Issue a different command.

Regards, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"James" <huyu...@gmail.coma écrit dans le message de news:
1166758178.889950.229...@80g2000cwy.googlegroups.c om...

Please ran the following commands as below. (databae is V8 fix 11 on
AIX)
1.db2 connect to DBNAME user db2inst3 using XXX
2.db2 get db cfg
Then receive an error: SQL1009N The command is not valid.

I can run "db2 list tables". What I concern is why I can not run "get
db cfg" command? I checked the database directory, that's ok. I found
the database was in inconsistent status when I ran db2dart tool.

Any advice?

Thank you so much!

James- Hide quoted text -- Show quoted text -

Dec 22 '06 #3

Pierre Saint-Jacques

Apologies for false presumptions of mine.

I think that because you are connected, the command gives you the db cfg of
what you are connected to. When no connect is given, then you have to
specify the dbname in the command, since db2 has no clue to which cfg of
many db's need to be retrieved.

Now if that fails with the name specified, it's another issue. In that
case, even if the db name is given, it means that the db is remote. GET DB
CFG is an instance level command and therefore requires attachment to the
instance owning the db: attach to <nodenameuser ... using ...

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"James" <hu*****@gmail.coma écrit dans le message de news:
11**********************@a3g2000cwd.googlegroups.c om...
Thanks.
1.When I connect to database, I can run "get db cfg" directly, need not
run "get db cfg for xxx"
2.I knew the meaning of SQL1009N. My question is why I can connect to
database and perform import, export and SQL statements and so on, just
failed on command "get db cfg" or "get db cfg for xxx". Just due to
catalog issue?
On Dec 22, 12:06 pm, "Pierre Saint-Jacques" <sesc...@invalid.net>
wrote:

The command should be
db2 get db cfg for DBNAME
Do following, for this or any other message:
db2 ? sql1009n

D:\SQLLIB\BIN>db2 ? sql1009n

SQL1009N The command is not valid.

Explanation:

The command is not supported when issued on a client-only
workstation or against remote databases. An example of such a
command is cataloging a local database.

The command cannot be processed.

User Response:

Possible solutions include:

o Issue the specified command from a non client-only
workstation or from the workstation where the database
resides.

o Verify that the database is cataloged correctly.

o Issue a different command.

Regards, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"James" <huyu...@gmail.coma écrit dans le message de news:
1166758178.889950.229...@80g2000cwy.googlegroups.c om...

Please ran the following commands as below. (databae is V8 fix 11 on
AIX)
1.db2 connect to DBNAME user db2inst3 using XXX
2.db2 get db cfg
Then receive an error: SQL1009N The command is not valid.

I can run "db2 list tables". What I concern is why I can not run "get
db cfg" command? I checked the database directory, that's ok. I found
the database was in inconsistent status when I ran db2dart tool.

Any advice?

Thank you so much!

James- Hide quoted text -- Show quoted text -

Dec 22 '06 #4

James

Thanks for your reply.
Pierre Saint-Jacques wrote:

Apologies for false presumptions of mine.

I think that because you are connected, the command gives you the db cfg of
what you are connected to. When no connect is given, then you have to
specify the dbname in the command, since db2 has no clue to which cfg of
many db's need to be retrieved.

Now if that fails with the name specified, it's another issue. In that
case, even if the db name is given, it means that the db is remote. GET DB
CFG is an instance level command and therefore requires attachment to the
instance owning the db: attach to <nodenameuser ... using ...

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"James" <hu*****@gmail.coma écrit dans le message de news:
11**********************@a3g2000cwd.googlegroups.c om...
Thanks.
1.When I connect to database, I can run "get db cfg" directly, need not
run "get db cfg for xxx"
2.I knew the meaning of SQL1009N. My question is why I can connect to
database and perform import, export and SQL statements and so on, just
failed on command "get db cfg" or "get db cfg for xxx". Just due to
catalog issue?
On Dec 22, 12:06 pm, "Pierre Saint-Jacques" <sesc...@invalid.net>
wrote:
The command should be
db2 get db cfg for DBNAME
Do following, for this or any other message:
db2 ? sql1009n

D:\SQLLIB\BIN>db2 ? sql1009n

SQL1009N The command is not valid.

Explanation:

The command is not supported when issued on a client-only
workstation or against remote databases. An example of such a
command is cataloging a local database.

The command cannot be processed.

User Response:

Possible solutions include:

o Issue the specified command from a non client-only
workstation or from the workstation where the database
resides.

o Verify that the database is cataloged correctly.

o Issue a different command.

Regards, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"James" <huyu...@gmail.coma écrit dans le message de news:
1166758178.889950.229...@80g2000cwy.googlegroups.c om...

Please ran the following commands as below. (databae is V8 fix 11 on
AIX)
1.db2 connect to DBNAME user db2inst3 using XXX
2.db2 get db cfg
Then receive an error: SQL1009N The command is not valid.

I can run "db2 list tables". What I concern is why I can not run "get
db cfg" command? I checked the database directory, that's ok. I found
the database was in inconsistent status when I ran db2dart tool.

Any advice?

Thank you so much!

James- Hide quoted text -- Show quoted text -

Dec 23 '06 #5

Similar topics

SVD Back Solve Question

by: Oracle3001 | last post by:

Hi All, I am looking to use SVD to solve an equation of the form Aa = B, where a is 1 row x 11 col A is 2 rows x 11 col B is 2 rows x 1 col I know from the information I am reading I need...

Java

[Newb] Still not able to solve class attribution

by: Knoppix User | last post by:

Hi folks I still have not been able to solve this one, which didn't manage to garner a response yesterday, so I'm rephrasing it here. If I define an attribute in the __init__ statement of a...

Python

any Python equivalent of Math::Polynomial::Solve?

by: Just | last post by:

While googling for a non-linear equation solver, I found Math::Polynomial::Solve in CPAN. It seems a great little module, except it's not Python... I'm especially looking for its poly_root()...

Python

How to solve timeout problem?

by: BVM | last post by:

Hi, All: I have this error. It seems execution time is too long. Actually the execution time is about 30 seconds(I tested in Query analyzer). How do I solve this problem? ...

.NET Framework

How to solve this gracefully?

by: Alex | last post by:

Hi, I have a problem involving some design issue. I have two unrelated (that is, they do not derive from the same base) classes: ClassA ClassB Both have a quite similar interface, so they can...

C / C++

Ways to solve a puzzle in C++ -- variety

by: Alf P. Steinbach | last post by:

I'm writing a little piece on pointers, to be "bundled" with my attempted correct C++ tutorial (see FAQ item 29.20, yes, I've finally started to at least think about that again), and while thinking...

C / C++

how to solve these equations

by: vj | last post by:

Hi all, I want to solve the two equations u*tan(u)=w and u^2 + w^2=V^2, where V is a known constant, and u and w are the two unknowns to be determined. Please can someone suggest me how to...

C / C++

How to solve Complex Query Error !

by: arun | last post by:

Query is too complex -------------------------------------------------------------------------------- Hi, I was trying to solve this problem since last two days but couldn't find any solution. ...

Microsoft Access / VBA

Violation of PRIMARY KEY constraint..how to solve this error?

by: akmaRudiliyn | last post by:

Hai everybody :). I have problem and need help. ERROR: ERROR Violation of PRIMARY KEY constraint 'PK_Table1_01'. Cannot insert duplicate key in object 'dbo.table1'. ERROR The statement has...

Microsoft SQL Server

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing