Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Tablespace

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
hanifam
Warnings : 1

New User


Joined: 04 Aug 2009
Posts: 4
Location: Chennai

PostPosted: Tue Aug 10, 2010 3:21 pm    Post subject: DB2 Tablespace
Reply with quote

Hi Folks,

In my system... I am having two regions in DB2(Production and Test)......

Example:

For Table A.... Database and Tablespaces name was same in both Prod and Test Region, it is possible.....

How it can be differ while i am unload the data from production and load in to test.

Please clarify my doubts..

Thanks & Regards,
H.Mohideen
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Aug 10, 2010 3:23 pm    Post subject:
Reply with quote

ever heard of subsystem or SSID ?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Aug 10, 2010 8:11 pm    Post subject:
Reply with quote

Hello,

Quote:
How it can be differ while i am unload the data from production and load in to test.
If you do not completely understand this, do not load any data. . . You could easily destroy the production environment if you have permission to load there. . . And probably not have any idea that there was a problem until someone reported it. . .
Back to top
View user's profile Send private message
hanifam
Warnings : 1

New User


Joined: 04 Aug 2009
Posts: 4
Location: Chennai

PostPosted: Thu Aug 19, 2010 6:16 pm    Post subject: Time Parameter
Reply with quote

One of my job was abended with S322....

After that i have used TIME parameter in jobcard

TIME=1440

But i got an error like

JOB CANCELLED BY INSTALLATION EXIT - IEFUJV....

How can i resolve please help me out on this...

Thanks & Regards,
H.Mohideen
Ph - 9940146876 [/b]
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Aug 19, 2010 6:46 pm    Post subject:
Reply with quote

Talk to your site support people about resources allocated to job classes, they are THE ONLY people who will know.

Also, please remove any personal contact details from your footer data.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 19, 2010 9:26 pm    Post subject:
Reply with quote

Hello,

Quote:
After that i have used TIME parameter in jobcard

TIME=1440
The worst possible choice. . .

Do NOT use 1440 . . . You may believe your job is that important, but the organization's management probably does not.

Quote:
But i got an error like

JOB CANCELLED BY INSTALLATION EXIT - IEFUJV....
Many systems are set up to automatically cancel any developer/user job submitted with 1440.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Aug 19, 2010 11:31 pm    Post subject:
Reply with quote

Are the post from OP are in connection with each other somewhere, I'm lost icon_sad.gif. Why a question about SSID turns to TIME=1440?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 20, 2010 12:43 am    Post subject:
Reply with quote

Hi Anuj,

Because hanifam chose to reply to a topic that hanifam posted rather than properly starting a new topic. . .?

Also, the personal data hasn't been removed from the "signature" as requested.

If hanifam replies, we can see if this needs to be split or if there is some reason to have these together. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm
No new posts BMC UNLOAD for a LOB tablespace JyothsnaNayak DB2 2 Wed Jul 29, 2015 2:02 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us