Partitioning through MaxL from one server to another server

Partitioning through MaxL from one server to another server

Joined: March 10th, 2011, 5:23 pm

November 23rd, 2011, 8:30 am #1

Hi All,

We have a requirement like we need to do the transparent partition using MaxL from the ASO Source cube on one server to the BSO target cube on another server.

I am struck up at

drop transparent partition 'sourceServer'.'sourceAppl'.'sourceDB' to 'targetAppl'.'targetDB' at 'targerServer';

create transparent partition 'sourceServer'.'sourceAppl'.'sourceDB' area 'sourceArea' to 'targetAppl'.'targetDB' at 'targerServer' as Username identified by 'password' area 'targetArea' mapped globally (sourceMember) to (targetMember);

I am receiving syntax error at the 'sourceServer'.'sourceAppl'.'sourceDB'.

Could any one of you pls suggest me how to represent the Source Server in the MaxL while partitioning from one server to another.

Thanks in Advance.

Regards...
Kumar
Reply
Like
Share

Joined: April 13th, 2011, 5:00 pm

November 23rd, 2011, 2:43 pm #2

Run the command while connected to the source server. There is no need to specify the source server in the CREATE command.
Reply
Like
Share

Joined: March 10th, 2011, 5:23 pm

November 29th, 2011, 5:42 am #3

Thank You for your reply.

Actually, I am creating the partition from Target Server, so used the partition like 'targetApp'.'targetDb' from 'sourceApp'.'sourceDb' at 'sourceServer' and removed the name of target Server. It worked well.
Reply
Like
Share


Confirmation of reply: