473,574 Members | 2,264 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

9.1 db2look against 8.2 database

Hi!

On one machine I have DB2 8.2.4 and on one I have DB2 9.1.
If I run db2look from the DB2 9.1 machine against a database that is on the
DB2 8.2.4 I get:
SQL5060N The configuration parameter token specified is invalid.

Any ideas how to resolve this ?

Best regards,
Kovi

--
----------- Gregor Kovac -----------------------------------
In A World Without Fences Who Needs Gates? Experience Linux.
Sep 19 '06 #1
1 2921
Gregor Kovac( wrote:
Hi!

On one machine I have DB2 8.2.4 and on one I have DB2 9.1.
If I run db2look from the DB2 9.1 machine against a database that is on the
DB2 8.2.4 I get:
SQL5060N The configuration parameter token specified is invalid.

Any ideas how to resolve this ?
I don't see a way around it. Obviously db2look internally is looking for
something DB2 V8 doesn't have. Unless you find documentation that states
that db2look supports back level releases (which I doubt) this wouls be
considered to work as designed.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 19 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
10693
by: John Gritmon | last post by:
I am executing the following command: db2look -d database -e -l -o database.out and when the create tablespace ddl is generated I get the following which is missing all of the container information. CREATE REGULAR TABLESPACE USERSPACE1 IN NODEGROUP DATA_NODE_9 PAGESIZE 4096 MANAGED BY SYSTEM EXTENTSIZE 16
3
9956
by: dbtoo_dbtoo | last post by:
One of the databases has 50 views and when I do a db2look I only get schema for 40 of them. If I select from the sysviews, I can see all 50 (the text column contains schema for all 10 (missing) views). What's going on here? Why can't or how can I get the schema for these 10 views. Aix 5.1 V7.2 EE FP9 Thanks.
1
1994
by: db2group88 | last post by:
about db2look, if i want to extract the ddl from one schema then reproduce the database objects on different server with different schema, is it a way to do it? e.g. we provide the same ddl structure for different clients, but must be under different schema names for different customers.
6
5342
by: sriram | last post by:
Hi, I have been seing a weird problem with db2look tool in db2 8.2 on Windows 2000 platform. When i spool the DDL using db2look, it spools the DDL in the ascending order of database objects Timestamp and not in the ascending order of db objects name. I need to spool the DDL in the ascending order db names. Can anyone
8
3560
by: db2sysc | last post by:
All: I tried to run db2look on V8.2 DB for getting ALL the DLLS for the database. When I look into the output file, the SQL procedures code is not present. Instead I see an external entry associated with db2pvm. I understand that db2pvm is being introduced for instead of C compiler. My question is how do I get the DDLs for the SQL...
2
12438
by: shsandeep | last post by:
Hi, I executed the following db2look statement but got an 'Execute' privilege error. What privileges do I need to execute the 'db2look' utility? /home# db2look -d dbname -e -o sql.txt -- No userid was specified, db2look tries to use Environment variable USER -- USER is: SAPSAS -- Creating DDL for table(s) -- Output is sent to file:...
2
4059
by: Justin | last post by:
Is there a way to get the ddl for a subset of tables? In this case, get all the tables beginning with emp from the sample db? Example db2look -e -tw emp* -d sample
0
1165
by: MeBuggyYouJane | last post by:
When running db2look from ESE/xp/8.2.7 against a xp/8.1.6, it runs fine except (at least) when the -l switch is set, to get tablespaces and the like. With that switch, the 1427N is thrown. The ESE/8.2.7 does have federated databases, but not the one being looked. A scan of the APARS and this list reveal nothing. More oddly, running the...
1
4723
by: blaisestephen | last post by:
I have a dilema where I want to run DB2LOOK to keep copies of our table DDL's and procedures for our schema. the problem is that we do not even have select privilege for the SYSCAT schema, which stops the DB2LOOK with authority errors. This is one of those situations where we are using the schema on another companys computer and database that we...
1
7808
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8096
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6450
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5616
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5299
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3739
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3749
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1335
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1055
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.