dataset management

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

dataset management

Post by reachmexyz »

hello all

I am trying to delete the dataset through Dataset management option. But when i click on Dataset management button, i was direclty taken to location like "/dsProj/Datasets" where i can see datasets, but cannot delete them.

I remember, in version 7.5.2, when i click Dataset management, a new window used to open which has row count on each node, options to delete dataset, copy dataset etc. I couldnt see that window in 8.1.

I wish to delete datasets through Dataset management only, but not trough orchadmin command. Please reply.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

What happens when you choose a dataset in the window; doesn't it open up the dataset details window?
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

Post by reachmexyz »

ArndW wrote:What happens when you choose a dataset in the window; doesn't it open up the dataset details window?
It doesnt open any details. When i clicked it, window is closed and returned to designer.
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

Post by reachmexyz »

reachmexyz wrote:
ArndW wrote:What happens when you choose a dataset in the window; doesn't it open up the dataset details window?
It doesnt open any details. When i clicked it, window is closed and returned to designer.
When i clicked it, it is trying to open something and i can see that as a white screen. But it stays as a white screen for a long time. Then i have top forcibly close the designer window.
rajadommeti
Premium Member
Premium Member
Posts: 43
Joined: Wed Feb 27, 2008 1:08 am

Re: dataset management

Post by rajadommeti »

reachmexyz wrote:hello all

I am trying to delete the dataset through Dataset management option. But when i click on Dataset management button, i was direclty taken to location like "/dsProj/Datasets" where i can see datasets, but cannot delete them.

I remember, in version 7.5.2, when i click Dataset management, a new window used to open which has row count on each node, options to delete dataset, copy dataset etc. I couldnt see that window in 8.1.

I wish to delete datasets through Dataset management only, but not trough orchadmin command. Please reply.
There is a delete button on the top right. I also use 8.1 and i could delete dataset using Dataset Management. Click on Tools --> Dataset Management , Then select .ds file it will open a window and you can see #partition,nodes and also delete button.
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

Re: dataset management

Post by reachmexyz »

rajadommeti wrote:
reachmexyz wrote:hello all

I am trying to delete the dataset through Dataset management option. But when i click on Dataset management button, i was direclty taken to location like "/dsProj/Datasets" where i can see datasets, but cannot delete them.

I remember, in version 7.5.2, when i click Dataset management, a new window used to open which has row count on each node, options to delete dataset, copy dataset etc. I couldnt see that window in 8.1.

I wish to delete datasets through Dataset management only, but not trough orchadmin command. Please reply.
There is a delete button on the top right. I also use 8.1 and i could delete dataset using Dataset Management. Click on Tools --> Dataset Management , Then select .ds file it will open a window and you can see #partition,nodes and also delete button.



I have created a ds file and when i checked the dataset management window, i see no nodes. But total records were listed on the right, but the node distribution is not present. I couldnt understand whats going on. Where the records are created and i dont know why it is not showing the nodes in dataset management window. For some other jobs, it is showing the nodes.
rajadommeti
Premium Member
Premium Member
Posts: 43
Joined: Wed Feb 27, 2008 1:08 am

Re: dataset management

Post by rajadommeti »

reachmexyz wrote:
rajadommeti wrote:
reachmexyz wrote:hello all

I am trying to delete the dataset through Dataset management option. But when i click on Dataset management button, i was direclty taken to location like "/dsProj/Datasets" where i can see datasets, but cannot delete them.

I remember, in version 7.5.2, when i click Dataset management, a new window used to open which has row count on each node, options to delete dataset, copy dataset etc. I couldnt see that window in 8.1.

I wish to delete datasets through Dataset management only, but not trough orchadmin command. Please reply.
There is a delete button on the top right. I also use 8.1 and i could delete dataset using Dataset Management. Click on Tools --> Dataset Management , Then select .ds file it will open a window and you can see #partition,nodes and also delete button.



I have created a ds file and when i checked the dataset management window, i see no nodes. But total records were listed on the right, but the node distribution is not present. I couldnt understand whats going on. Where the records are created and i dont know why it is not showing the nodes in dataset management window. For some other jobs, it is showing the nodes.
Click on Refresh button on dataset management window.
RAJ
dsxuserrio
Participant
Posts: 82
Joined: Thu Dec 02, 2004 10:27 pm
Location: INDIA

Post by dsxuserrio »

It is possible that the control file (.ds) is still there, but the actual data has been deleted. View the data/Try an orchadmin dump <dataset> to see if the data is still there.

When was this dataset created? After creation did you make any hardware/node changes?
dsxuserrio

Kannan.N
Bangalore,INDIA
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Re: dataset management

Post by JoshGeorge »

In your case by default dataset folder is holding the data files and the header (.ds) files are most probably in your project folder somewhere. [Search the RT_xxx folders, if you know the job number which created the datasets search those RT_xxx folders]. From there you will be able to do what you intend to do.
reachmexyz wrote:hello all

I am trying to delete the dataset through Dataset management option. But when i click on Dataset management button, i was direclty taken to location like "/dsProj/Datasets" where i can see datasets, but cannot delete them.

I remember, in version 7.5.2, when i click Dataset management, a new window used to open which has row count on each node, options to delete dataset, copy dataset etc. I couldnt see that window in 8.1.

I wish to delete datasets through Dataset management only, but not trough orchadmin command. Please reply.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply