472,794 Members | 1,790 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,794 software developers and data experts.

db2move issue with as400 iSeries library

Hi team,

Has anyboby faced this issue?
I'm trying to use db2move to export as400 schema content to my local windows file system.
The aim is to be able to re-import it into a DB2 UDB v9 Windows server.

################################################## ##############

C:\DB2_bin\DB2_tips>db2move AS400DB EXPORT -u SRLA -p SRLA -sn XSIFIC

Application code page not determined, using ANSI codepage 1252

***** DB2MOVE *****

Action: EXPORT

Start time: Tue Apr 28 09:33:01 2009

All schema names matching: XSIFIC;

Connecting to database AS400DB ... successful! Server's Product Signature: QSQ05040

Error: Unknown DB2 Server!

**Error - Unknown server.

Disconnecting from database ... successful!

End time: Tue Apr 28 09:33:01 2009

C:\DB2_bin\DB2_tips>
################################################## ##############
Apr 28 '09 #1
1 4277
do you have db2 connect installed ? have you tried a simple connect and select to as/400 ?
also something with codepage : try chcp to see the codepage
and the codepage of as/400 db2
best regards, guy przytula
Jun 14 '09 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: CompDude | last post by:
Hi All I am trying to copy data from DB2 to SQL server using SQL Data Tranformation Services. I am able to do that by supplying AS400 username/password along with the iSeries DSN Name, at the...
13
by: Sehboo | last post by:
Hello, we have data sitting on AS400 (V4R5M0) - DB2-400. I need to access that from my vb.net application. I don't know anything about AS400. Is it possible to get data from tables and stored...
5
by: Nathan Given | last post by:
Hello All, I've been struggling on and off for 3 months trying to connect to an DB2 database running on an IBM iSeries machine. I FINALLY figured out how to connect with Coldfusion (see...
3
by: Russ | last post by:
My company is running DB2 on AS400 iSeries V5R3 and making a strong push to move from RPG/External stored procs to SQL stored procs. My background is Oracle/SQL Server and am used to using some...
2
by: chmmr | last post by:
Hello, I would like to ask if there are any differences between DB2 in these versions (e.g. support of triggers, Java stored procedures and such). Also, does anyone know from which DB2 AS/400...
1
by: kellyj00 | last post by:
Hello. I'm new to the world of the as400, but not to the world of SQL and relational databases. I would like to create a view on our as400 machine, but I understand that creating a view will...
1
by: Jones | last post by:
Hello people, I am new to this platform and database. I need to analyze an application on the AS400 and therefore need to know the operation it does on the database. So has anybody links to...
6
by: Al G | last post by:
Can someone tell me what I need to get connected to our AS400? I am trying to write an app in VS2005(Data source, Gridview) that requires data from files on our AS400. I've downloaded DB2, and...
2
by: Eniacson | last post by:
I've worked with DB2 for a long time, but I'm new to the AS400 environment. I'm having a problem with an SQL statement that runs perfectly when I use STRSQL, but when I batch it and call...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.