DCOLLECT Issue

Devyani Ramesh

DCOLLECT Issue
Dear List,

I am currently running DCOLLECT and loading the output information into DB2 tables. However, wierd thing which I found out was like despite of data in the table and ultimately datasets allocation is more than zero, SPACE ALLOCATED show zero. I think space used can be zero in case of no data in the table but this has got something weird with space allocated as zero.

I am collect statistics separately for the migrated datasets. Please can you tell any reason as why it is reporting in correctly?

Thanks a lot.

Devyani

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Lizette Koehler

Re: DCOLLECT Issue
(in response to Devyani Ramesh)
Well first DCOLLECT is not a DB2 Function. That belongs to IDCAMS. So you should probably ask your question on the IBM Main newsgroup.

Second, are you sure you are parsing the DCOLLECT records correctly? Have you validate the record type and data in that record type.

But I would suggest that you post this over on IBM MAIN and not DB2 newsgroup.

Lizette



-----Original Message-----
>From: Devyani Sahasrabuddhe <[login to unmask email]>
>Sent: Jan 14, 2011 4:18 PM
>To: [login to unmask email]
>Subject: [DB2-L] DCOLLECT Issue
>
>Dear List,
>
>I am currently running DCOLLECT and loading the output information into DB2 tables. However, wierd thing which I found out was like despite of data in the table and ultimately datasets allocation is more than zero, SPACE ALLOCATED show zero. I think space used can be zero in case of no data in the table but this has got something weird with space allocated as zero.
>
>I am collect statistics separately for the migrated datasets. Please can you tell any reason as why it is reporting in correctly?
>
>Thanks a lot.
>
>Devyani
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2 information. *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>How can you expand your staff or do succession planning in this economy?
>Mentoring is a proven, economical, way to train the next generation of DB2 Users!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Lizette Koehler

Re: DCOLLECT Issue
(in response to Lizette Koehler)
I forgot one other question

Is you DDL correct with respect to the data. Are you using a DB2 LOAD function to update your DB2 Table? If so, are you getting any errors with respect to the load.

Do you have a tool like SAS and MXG that does a very nice job with DCOLLECT data?

Lizette


-----Original Message-----
>From: Devyani Sahasrabuddhe <[login to unmask email]>
>Sent: Jan 14, 2011 4:18 PM
>To: [login to unmask email]
>Subject: [DB2-L] DCOLLECT Issue
>
>Dear List,
>
>I am currently running DCOLLECT and loading the output information into DB2 tables. However, wierd thing which I found out was like despite of data in the table and ultimately datasets allocation is more than zero, SPACE ALLOCATED show zero. I think space used can be zero in case of no data in the table but this has got something weird with space allocated as zero.
>
>I am collect statistics separately for the migrated datasets. Please can you tell any reason as why it is reporting in correctly?
>
>Thanks a lot.
>
>Devyani
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2 information. *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>How can you expand your staff or do succession planning in this economy?
>Mentoring is a proven, economical, way to train the next generation of DB2 Users!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Colin

Re: DCOLLECT Issue
(in response to Lizette Koehler)
Devyani,



As Lizette says, this is not particularly a DB2 question, but we may be able to help.



When you say SPACE ALLOCATED shows zero, what exactly do you mean ? Is this in the output from DCOLLECT, or are you questioning the allocation of the DB2 tables that you loaded the data into ?



Maybe you just need to run RUNSTATS.



Regards,



Colin Clayton


DB2 DBA
DB2 Projects
MMTS Databases
Central Infrastructure Services
Business Services
Grnd Floor,
34 Fettes Row,
Edinburgh
EH3 6UY


(External 0131 523 2221
(Internal (777) 222221



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Devyani Sahasrabuddhe
Sent: 14 January 2011 21:18
To: [login to unmask email]
Subject: [DB2-L] DCOLLECT Issue





Dear List,

I am currently running DCOLLECT and loading the output information into DB2 tables. However, wierd thing which I found out was like despite of data in the table and ultimately datasets allocation is more than zero, SPACE ALLOCATED show zero. I think space used can be zero in case of no data in the table but this has got something weird with space allocated as zero.

I am collect statistics separately for the migrated datasets. Please can you tell any reason as why it is reporting in correctly?

Thanks a lot.

Devyani

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1191 / Virus Database: 1435/3379 - Release Date: 01/14/11



_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv