ChannelDB2

darshan
  • Male
  • Frederick, MD
  • United States
Share on Facebook Share on Facebook Share

Darshan's Friends

  • Luyza Tavares Alexandre

darshan's Groups

darshan's Discussions

LOB Migration from Sybase to UDB

Started May 15, 2008

Gifts Received

Gift

darshan has not received any gifts yet

Give a Gift

 

darshan's Page

Profile Information

Full Name:
Darshan Vaishnav
Job Title:
Sr. Database Anaylyst
Company:
Marriott International
Homepage/Blog:
http://db2udb-darshan.blogspot.com
Platforms of Interest:
Linux/UNIX/Windows

Darshan's Blog

Some strange issue in Redirected restore... part-1

Posted on August 5, 2009 at 11:09pm 0 Comments

Ok so here is the scenario..



- Have database1 in db2inst1

- Took a offline (cold) backup of database1

- did redirected restore to clone database1 in to database2 in same instance

- set tablespace containers, worked just fine , no errors.

- roll forward database to end of logs and complete , worked fine no errors



Now problem starts. When app folks told me they are missing some data, which was simply not visible to me because I did cold backup and then… Continue

Stupid issue in accessing tables !!

Posted on May 6, 2009 at 10:00am 2 Comments

Stupid me.. !! And I guess thats how I learn new things... !!



I got a request from our performance team that we have to move tables from default tablespace to new tablespace to improve performance.



So I did following



1. Created a duplicate tables

2. Preserved data by "insert into temp select * from main"

3. generated DDL with grants,aliases etc.

4. change the tablespace name in DDL

5. Drop main tables

6. Created new tablew with modified… Continue

Comment Wall (3 comments)

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

At 7:15am on October 5, 2010, Luyza Tavares Alexandre said…
Cheers! Very happy with new work, thank you.

That's what i did with my containers. All allocated ;)

So, another question. Could i duplicate database through container physical copy? I can do it in Oracle and works!

I did that test at home, works, but i'm in doubt about future problems.

Thanks Darshan, have a nice week.
At 2:05pm on September 27, 2010, Luyza Tavares Alexandre said…
Hey, where are you dear?
All container allocated with IBM Support help ;)


Thanks...
At 4:24pm on September 21, 2010, Luyza Tavares Alexandre said…
Hey Darshan, how are you? Do you remember me?
I'm working with db2 now! There are 2 months.

Data Warehouse: Cognos + DB2;

What you think? Did you already work with data warehouse enviroments?

I need to allocate containers for my production enviroments this week and i'm really in doubt about "Rebalancing Containers". Should i to allocate all containers that i can once or to allocate after when i need;

What is the exactly the cost of rebalancing containers for data warehouse enviroments?

Could you help me? My email: luyza@riachuelo.com.br

Thanks ;)
 
 
 

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service