RE: Requried soluriont --- Very urgent----Error when migrating from Oracle 9i to DB2 UDB V8.1 --- Required help to list procedures

RE: Requried soluriont --- Very urgent----Error when migrating from Oracle 9i to DB2 UDB V8.1 --- Required help to list procedures

 

  

Are you sure this is not a security issue and the userid you are using
to login to control center does not have proper authority to the sp?
Seeing it from one machine and not another would lead me to believe a
security issue..
MM


-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x67672895.[Email address protected]
Sent: Thursday, December 30, 2004 7:40 AM
To: LazyDBA Discussion
Subject: RE: Requried soluriont --- Very urgent----Error when migrating
from Oracle 9i to DB2 UDB V8.1 --- Required help to list procedures





If you use 8.2, you will not see any executables in that path. They will
be
byte code in the database. When you bring up the control center, bring
it
up in advanced mode and see if you can see the SP's.


Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]





"Harish Reddy V.

"

<db2udbdba-ezmlms
To
hield-x83056137.x "LazyDBA Discussion"

[Email Address Removed] <[Email address protected]

a.com>
cc


12/30/2004 06:48
Subject
AM RE: Requried soluriont --- Very

urgent----Error when migrating
from
Oracle 9i to DB2 UDB V8.1 ---

Required help to list procedures

















Hi,

Thanks Partha for your reply.

I have checked for the procedure in the path given
<unstance-home>/sqllib/function/routine/sqlproc/<DB-name>/, but i could
not
find any procedure. I am using DB2 ESE V8.2 not 8.1(I hope in 8.1 we
will
able to see one dll, one sqc programs for the corresponding procedure).
I
am not sure whether same thing happens in 8.2 (Correct me if I am
wrong).

Note: We are trying to view these procedure from 2 different clients, we
were able to see the procedure from one client machine where as from
other
machine we are not able view the same procedure. This is very tricky
position for us.Somebody from this group help me out where am I going
wrong???

Thanks in advance...

Thanks & Regards,
Harish Reddy



-----Original Message-----
From: Parthasarathy Partha
[mailto:db2udbdba-ezmlmshield-x10688233.[Email address protected]
Sent: Thursday, December 30, 2004 4:38 PM
To: LazyDBA Discussion
Subject: RE: Requried soluriont --- Very urgent----Error when migrating
from Oracle 9i to DB2 UDB V8.1 --- Required help to list procedures


Hi Harish,

My first suggestion is to do a bind on the complete database.

[db2rbind <db-name> all -l /tmp/rebind.log ]

Use db2look utility to see all the objects involved in the database.

db2look -e -d <db-name>

On our system, the compiled SQL procs lie at

<unstance-home>/sqllib/function/routine/sqlproc/<DB-name>/

I know that this is not the solution but hope it drives to the solution.

Partha



-----Original Message-----

From: Harish Reddy V. [mailto:db2udbdba-ezmlmshield-x95515402.[Email
address protected]

Sent: Thu 12/30/2004 3:10 AM

To: LazyDBA Discussion

Cc:

Subject: RE: Requried soluriont --- Very urgent----Error when migrating
from Oracle 9i to DB2 UDB V8.1 --- Required help to list procedures









Hi All,



Further to my earlier question we were able to migrate the tables from
oracle to db2ese. We have tried to migrate the stored procedures too.
We
were able to see the stored procedures getting migrated in the
deployment
log file in the Migration Toolkit. But when I check the stored
procedures
in the control center, we were unable to stored procedure.Then we have
tried to migrate the single stored procedure, we got the error message
saying that stored procedure already present.We have dropped the stored
procedure using command line and again migrated the stored procedure
and
deployed it in the db2. After 2nd attempt also we were unable to trace
the
SP in the control center. Can anybody help me out how to see the stored
procedure from Control Center as well as from command line (Syntax
required).



Appreciate an early response from you guys



Thanks & Regards

Harish Reddy



-----Original Message-----

From: Harish Reddy V.

[mailto:db2udbdba-ezmlmshield-x71041447.[Email address protected]

Sent: Thursday, December 30, 2004 10:17 AM

To: LazyDBA Discussion

Subject: RE: Requried soluriont --- Very urgent----Error when migrating

from Oracle 9i to DB2 UDB V8.1





Hi,



With the support you have provided to us, we were able to migrate the
full
database except some foriegn key issues. The migration of full DB has
taken 7hrs this time where as earlier it has taken only 45min only. We
are
trying to find the excat reason ,I would like to know anybody in the
group
has come across such as situation after you have created 2 tablespaces
with 16kb and 32kb page size and tried to migrate the oracle db to db2
udb
.



Thanks in advance.

Thanks & Regards,

Harish Reddy



-----Original Message-----

From: Praveen Chengalathu

[mailto:db2udbdba-ezmlmshield-x24498740.[Email address protected]

Sent: Wednesday, December 29, 2004 8:58 PM

To: LazyDBA Discussion

Subject: RE: Requried soluriont --- Very urgent----Error when migrating

from Oracle 9i to DB2 UDB V8.1





Apologies...it should be tablespaces that you need to create...and also
the BP's with these pagesizes for these tablespaces....



-----Original Message-----

From: Praveen Chengalathu

[mailto:db2udbdba-ezmlmshield-x18713043.[Email address protected]

Sent: 29 December 2004 11:00

To: LazyDBA Discussion

Subject: RE: Requried soluriont --- Very urgent----Error when migrating

from Oracle 9i to DB2 UDB V8.1





You will have to create two bufferpools, one with 8K pagesize and the
other one with 16K pagesize and then run the DDL's below.





Look at DB2 SQL Reference for syntax.





-----Original Message-----

From: Harish Reddy V.

[mailto:db2udbdba-ezmlmshield-x56509203.[Email address protected]

Sent: 29 December 2004 07:26

To: LazyDBA Discussion

Subject: Requried soluriont --- Very urgent----Error when migrating
from

Oracle 9i to DB2 UDB V8.1





Hi,



We are in the process of migrating tables from Oracle 9i to DB2 using
IBM
Migration toolkit. We were able to migrate the 102 tables directly
where
as with other 15 tables we are facing the problem as described below
.Please find the error script below.



CREATE TABLE BSS_AI_ALLOC_SUMMARY( OPS_PLAN_NO FLOAT, ACT_CODE
VARCHAR(10), BRAND VARCHAR(4000), BUDGET DECIMAL(14,6), TONNAGE
DECIMAL(12,6), CATEGORY VARCHAR(4000), BRAND_CODES VARCHAR(4000),
ALLOCATED_TO_AREAS VARCHAR(1) DEFAULT 'B', CAT_CODE VARCHAR(4000),
DISCOUNT DECIMAL(10,2) )DB21034E The command was processed as an SQL
statement because it was not a valid Command Line Processor command.
During SQL processing it returned:SQL0286N A default table space could
not be found with a page size of at least "16384" that authorization ID
"SOL2USER" is authorized to use. SQLSTATE=42727



CREATE TABLE BSS_ADD_WRITEBACK_BDG( CHG_ALLOC_REQ_NO INTEGER NOT NULL,
OPS_PLAN_NO FLOAT NOT NULL, ACT_CODE VARCHAR(10) NOT NULL, CURR_STAGE
SMALLINT DEFAULT 1, CURR_SUB_STAGE SMALLINT DEFAULT 1, CHG_REQ_STATUS
VARCHAR(1) DEFAULT 'P', AUTO_MANUAL VARCHAR(1), APPR_ROLE INTEGER,
ADD_OR_WRITEBACK VARCHAR(1), GSM_OR_RSM VARCHAR(1), REASON
VARCHAR(2000),
CREATED_BY INTEGER, CREATED_ON DATE, MODIFIED_ON DATE, MODIFIED_BY
INTEGER, REMARKS VARCHAR(2000) )DB21034E The command was processed as
an
SQL statement because it was not a valid Command Line Processor
command.
During SQL processing it returned:SQL0286N A default table space could
not be found with a page size of at least "8192" that authorization ID
"SOL2USER" is authorized to use. SQLSTATE=42727



CREATE TABLE BSS_ALLOC_SUMMARY( OPS_PLAN_NO FLOAT, ACT_CODE
VARCHAR(10),
BRAND VARCHAR(4000), BRANCH VARCHAR(50), BUDGET DECIMAL(14,6), TONNAGE
DECIMAL(12,6), CATEGORY VARCHAR(4000), SALES_HIER_NO INTEGER,
ALLOCATED_TO_AREAS VARCHAR(1) DEFAULT 'B', BRAND_CODES VARCHAR(4000),
BRANCH_CODE VARCHAR(10), CAT_CODE VARCHAR(4000), DISCOUNT DECIMAL(10,2)
)DB21034E The command was processed as an SQL statement because it was
not a valid Command Line Processor command. During SQL processing it
returned:SQL0286N A default table space could not be found with a page
size of at least "16384" that authorization ID "SOL2USER" is authorized
to
use. SQLSTATE=42727



CREATE TABLE BSS_AI_HIST_ALLOC_SUMMARY( OPS_PLAN_NO FLOAT, ACT_CODE
VARCHAR(10), VERSION SMALLINT, BRAND VARCHAR(4000), BUDGET
DECIMAL(14,6),
TONNAGE DECIMAL(12,6), CATEGORY VARCHAR(4000), BRAND_CODES
VARCHAR(4000),
ALLOCATED_TO_AREAS VARCHAR(1) DEFAULT 'B', CAT_CODE VARCHAR(4000),
DISCOUNT DECIMAL(10,2) )DB21034E The command was processed as an SQL
statement because it was not a valid Command Line Processor command.
During SQL processing it returned:SQL0286N A default table space could
not be found with a page size of at least "16384" that authorization ID
"SOL2USER" is authorized to use. SQLSTATE=42727



Somebody from this group help us out in resolving the issue.



Thanks in advance



Thanks & Regards,

V.Harish Reddy







---------------------------------------------------------------------

PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE

website: http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html







---------------------------------------------------------------------

PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE

website: http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html







---------------------------------------------------------------------

PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE

website: http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html







---------------------------------------------------------------------

PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE

website: http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html







---------------------------------------------------------------------

PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE

website: http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html









---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




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