Ranjesh,

The first error you got is with the Time stamp conflict use the Correct
format and the second one you can Ignore.
Third one is the Important one which say's that you don't have access to
the 8 KB table space where the data should be put in because of the Row
Length of the table. And it is trying to create the table in the default
tablespace. Check you're access and get the USE of Tablespace of 8 KB
size and try it again.



Thanks and Regards,
Vishnu Vardan G.
Project Engineer , Wipro Technologies
Bengaluru,India.
>*:vishnuvardan.[Email address protected]
>*: 9740149105
>P Please don't print this e-mail unless you really need to. Save a
Tree.

-----Original Message-----
From: Ranjesh T Viswambharan
[mailto:db2udbdba-ezmlmshield-x9126699.[Email address protected]
Sent: Tuesday, February 19, 2008 7:27 PM
To: LazyDBA Discussion
Subject: Error while importing

Hi Guys,

Iam new to db2 world. I get the following error when i do following
import command

Import From C:\share\tmd.ixf Of Ixf Create Into db2admin.tmdefect

Kindly, help me to resolve the error attached below


Regards,
Ranjesh


SQL3150N The H record in the PC/IXF file has product "DB2 02.00",
date
"20080219", and time "180101".

SQL3153N The T record in the PC/IXF file has name
"C:\ranjesh\db2backup\export\tmd.ixf", qualifier "", and source "
".

SQL3319N An SQL error "-286" occurred while creating the table.

SQL0286N A default table space could not be found with a page size of
at least "8192" that authorization ID "DB2ADMIN" is authorized to use.
SQLSTATE=42727

SQL3110N The utility has completed processing. "0" rows were read from
the input file.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com


DB2 & UDB email list listserv db2-l LazyDBA home page