IDS Forum

RE: Split Up PSApBTAB dbspace

Posted By: NormaJean.Sebastian@tellabs.com
Date:

Sanjiv,
I also suggest using the SAPDBA tool during your reorg.
It will do the job, but you will have to do the thought work to figure
out your space requirements. SAPDBA will say something like "I have the
scripts ready, shall I run now". At that point, jump out/open new
session, go modify the scripts created by SAPDBA to change your dbspace
storage location and extent sizing (if desired), and let SAPDBA continue
it's job.

we scripted the onspaces commands to add dbspaces, then ran SAPDBA to
control most of the reorg, then scripted any remaining onspaces and
oncheck work.

test, test, test.
testing is very important as your SAP install may have a lot of Informix
table versioning (as ours does), which could hit you hard and gobble
more space than you think. Use "oncheck -pT" on the tables to figure it
out in advance (this will?may? (i forget) lock your tables and run a
long time... to avoid user complaints, run on a recently refreshed test
system).

Norma Jean


-----Original Message-----
From: John_Carlson@whsmithusa.com [mailto:John_Carlson@whsmithusa.com]
Sent: Wednesday, May 21, 2003 8:00 AM
To: ids@iiug.org; forum.subscriber@iiug.org
Subject: RE: Split Up PSApBTAB dbspace [1191]


Here's a very rough estimate of what you would need to do:

Take full Informix backup.
Create two new dbspaces.
Identify tables contained in original dbspace.
Unload data for given tables.
Create table schemas for given tables.
Update table schemas with 'new' dbspace storage location.
Drop tables.
Recreate tables using 'new' table schemas pointing to 'new' dbspace
location.
Load tables.
Recreate indices, etc. for tables.
Drop dbspace -- if any Informix objects are still there, then the
dbspace
will not drop -- further analysis required.

This assumes that:
Whole tables are contained in original dbspace (no parts of fragmented
tables).
Any detached indices in the original dbspace are tied to tables in the
original dbspace.
Anything else I may have forgotten -- insert standard disclaimer here .
. .
. .



-----Original Message-----
From: Sanjiv K Khiste [mailto:khistesk@LNTEBG.com]
Sent: Tuesday, May 20, 2003 11:39 PM
To: ids@iiug.org
Subject: Split Up PSApBTAB dbspace [1188]


Dear,

We are on NT / Inf 7.31TD2x4 .Our dbspace PSAPBTAB is growing currently
it
is 225gb.

We need to split this inot no of small dbspaces like PSAPBTAB1,PSAPBTAB2
...

Can you help me to tell the procedure for splitting up this dbspace.

Regards,
Sanjiv




"CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel
Retail. This email message and all attachments may contain legally
privileged and confidential information intended solely for the use of
the
addressee. If you are not the intended recipient, you should immediately
stop reading this message and delete it from the system. Any
unauthorized
reading, distribution, copying, or other use of this message or its
attachments is strictly prohibited. All personal messages express solely
the
sender's views and not those of WHSmith USA Travel Retail. This message
may
not be copied or distributed without this disclaimer."



--openmail-part-3d6cae2c-00000002
Content-Type: application/rtf
Content-Disposition: attachment; filename="BDY.RTF"
;Creation-Date="Wed, 21 May 2003 09:10:40 -0500"
Content-Transfer-Encoding: base64

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYw
XGZzd2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmls
XGZjaGFyc2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5l
dzt9fQ0Ke1xjb2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1
NTt9DQpcdWMxXHBhcmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIFNhbmppdixccGFyDQpJ
IGFsc28gc3VnZ2VzdCB1c2luZyB0aGUgU0FQREJBIHRvb2wgZHVyaW5nIHlvdXIgcmVvcmcu
XHBhcg0KSXQgd2lsbCBkbyB0aGUgam9iLCBidXQgeW91IHdpbGwgaGF2ZSB0byBkbyB0aGUg
dGhvdWdodCB3b3JrIHRvIGZpZ3VyZSBvdXQgeW91ciBzcGFjZSByZXF1aXJlbWVudHMuICBT
QVBEQkEgd2lsbCBzYXkgc29tZXRoaW5nIGxpa2UgIkkgaGF2ZSB0aGUgc2NyaXB0cyByZWFk
eSwgc2hhbGwgSSBydW4gbm93Ii4gIEF0IHRoYXQgcG9pbnQsIGp1bXAgb3V0L29wZW4gbmV3
IHNlc3Npb24sIGdvIG1vZGlmeSB0aGUgc2NyaXB0cyBjcmVhdGVkIGJ5IFNBUERCQSB0byBj
aGFuZ2UgeW91ciBkYnNwYWNlIHN0b3JhZ2UgbG9jYXRpb24gYW5kIGV4dGVudCBzaXppbmcg
KGlmIGRlc2lyZWQpLCBhbmQgbGV0IFNBUERCQSBjb250aW51ZSBpdCdzIGpvYi5ccGFyDQpc
cGFyDQp3ZSBzY3JpcHRlZCB0aGUgb25zcGFjZXMgY29tbWFuZHMgdG8gYWRkIGRic3BhY2Vz
LCB0aGVuIHJhbiBTQVBEQkEgdG8gY29udHJvbCBtb3N0IG9mIHRoZSByZW9yZywgdGhlbiBz
Y3JpcHRlZCBhbnkgcmVtYWluaW5nIG9uc3BhY2VzIGFuZCBvbmNoZWNrIHdvcmsuXHBhcg0K
XHBhcg0KdGVzdCwgdGVzdCwgdGVzdC5ccGFyDQp0ZXN0aW5nIGlzIHZlcnkgaW1wb3J0YW50
IGFzIHlvdXIgU0FQIGluc3RhbGwgbWF5IGhhdmUgYSBsb3Qgb2YgSW5mb3JtaXggdGFibGUg
dmVyc2lvbmluZyAoYXMgb3VycyBkb2VzKSwgd2hpY2ggY291bGQgaGl0IHlvdSBoYXJkIGFu
ZCBnb2JibGUgbW9yZSBzcGFjZSB0aGFuIHlvdSB0aGluay4gIFVzZSAib25jaGVjayAtcFQi
IG9uIHRoZSB0YWJsZXMgdG8gZmlndXJlIGl0IG91dCBpbiBhZHZhbmNlICh0aGlzIHdpbGw/
bWF5PyAoaSBmb3JnZXQpIGxvY2sgeW91ciB0YWJsZXMgYW5kIHJ1biBhIGxvbmcgdGltZS4u
LiB0byBhdm9pZCB1c2VyIGNvbXBsYWludHMsIHJ1biBvbiBhIHJlY2VudGx5IHJlZnJlc2hl
ZCB0ZXN0IHN5c3RlbSkuXHBhcg0KXHBhcg0KTm9ybWEgSmVhblxwYXINClxwYXINClxwYXIN
Ci0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tXHBhcg0KRnJvbTogSm9obl9DYXJsc29uQHdo
c21pdGh1c2EuY29tIFttYWlsdG86Sm9obl9DYXJsc29uQHdoc21pdGh1c2EuY29tXVxwYXIN
ClNlbnQ6IFdlZG5lc2RheSwgTWF5IDIxLCAyMDAzIDg6MDAgQU1ccGFyDQpUbzogaWRzQGlp
dWcub3JnOyBmb3J1bS5zdWJzY3JpYmVyQGlpdWcub3JnXHBhcg0KU3ViamVjdDogUkU6IFNw
bGl0IFVwIFBTQXBCVEFCIGRic3BhY2UgWzExOTFdXHBhcg0KXHBhcg0KXHBhcg0KSGVyZSdz
IGEgdmVyeSByb3VnaCBlc3RpbWF0ZSBvZiB3aGF0IHlvdSB3b3VsZCBuZWVkIHRvIGRvOlxw
YXINClxwYXINClRha2UgZnVsbCBJbmZvcm1peCBiYWNrdXAuXHBhcg0KQ3JlYXRlIHR3byBu
ZXcgZGJzcGFjZXMuXHBhcg0KSWRlbnRpZnkgdGFibGVzIGNvbnRhaW5lZCBpbiBvcmlnaW5h
bCBkYnNwYWNlLlxwYXINClVubG9hZCBkYXRhIGZvciBnaXZlbiB0YWJsZXMuXHBhcg0KQ3Jl
YXRlIHRhYmxlIHNjaGVtYXMgZm9yIGdpdmVuIHRhYmxlcy5ccGFyDQpVcGRhdGUgdGFibGUg
c2NoZW1hcyB3aXRoICduZXcnIGRic3BhY2Ugc3RvcmFnZSBsb2NhdGlvbi5ccGFyDQpEcm9w
IHRhYmxlcy5ccGFyDQpSZWNyZWF0ZSB0YWJsZXMgdXNpbmcgJ25ldycgdGFibGUgc2NoZW1h
cyBwb2ludGluZyB0byAnbmV3JyBkYnNwYWNlXHBhcg0KbG9jYXRpb24uXHBhcg0KTG9hZCB0
YWJsZXMuXHBhcg0KUmVjcmVhdGUgaW5kaWNlcywgZXRjLiBmb3IgdGFibGVzLlxwYXINCkRy
b3AgZGJzcGFjZSAtLSBpZiBhbnkgSW5mb3JtaXggb2JqZWN0cyBhcmUgc3RpbGwgdGhlcmUs
IHRoZW4gdGhlIGRic3BhY2VccGFyDQp3aWxsIG5vdCBkcm9wIC0tIGZ1cnRoZXIgYW5hbHlz
aXMgcmVxdWlyZWQuXHBhcg0KXHBhcg0KVGhpcyBhc3N1bWVzIHRoYXQ6XHBhcg0KV2hvbGUg
dGFibGVzIGFyZSBjb250YWluZWQgaW4gb3JpZ2luYWwgZGJzcGFjZSAobm8gcGFydHMgb2Yg
ZnJhZ21lbnRlZFxwYXINCnRhYmxlcykuXHBhcg0KQW55IGRldGFjaGVkIGluZGljZXMgaW4g
dGhlIG9yaWdpbmFsIGRic3BhY2UgYXJlIHRpZWQgdG8gdGFibGVzIGluIHRoZVxwYXINCm9y
aWdpbmFsIGRic3BhY2UuXHBhcg0KQW55dGhpbmcgZWxzZSBJIG1heSBoYXZlIGZvcmdvdHRl
biAtLSBpbnNlcnQgc3RhbmRhcmQgZGlzY2xhaW1lciBoZXJlIC4gLiAuXHBhcg0KLiAuXHBh
cg0KXHBhcg0KXHBhcg0KXHBhcg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS1ccGFyDQpG
cm9tOiBTYW5qaXYgSyBLaGlzdGUgW21haWx0bzpraGlzdGVza0BMTlRFQkcuY29tXSBccGFy
DQpTZW50OiBUdWVzZGF5LCBNYXkgMjAsIDIwMDMgMTE6MzkgUE1ccGFyDQpUbzogaWRzQGlp
dWcub3JnXHBhcg0KU3ViamVjdDogU3BsaXQgVXAgUFNBcEJUQUIgZGJzcGFjZSBbMTE4OF0g
XHBhcg0KXHBhcg0KXHBhcg0KRGVhcixccGFyDQpccGFyDQpXZSBhcmUgb24gTlQgLyBJbmYg
Ny4zMVREMng0IC5PdXIgZGJzcGFjZSBQU0FQQlRBQiBpcyBncm93aW5nIGN1cnJlbnRseSBp
dFxwYXINCmlzIDIyNWdiLlxwYXINClxwYXINCldlIG5lZWQgdG8gc3BsaXQgdGhpcyBpbm90
IG5vIG9mIHNtYWxsIGRic3BhY2VzIGxpa2UgUFNBUEJUQUIxLFBTQVBCVEFCMlxwYXINCi4u
Li5ccGFyDQpccGFyDQpDYW4geW91IGhlbHAgbWUgdG8gdGVsbCB0aGUgcHJvY2VkdXJlIGZv
ciBzcGxpdHRpbmcgdXAgdGhpcyBkYnNwYWNlLlxwYXINClxwYXINClJlZ2FyZHMsXHBhcg0K
U2Fuaml2XHBhcg0KXHBhcg0KXHBhcg0KXHBhcg0KIFxwYXINCiJDT05GSURFTlRJQUxJVFkg
Tk9USUNFOiBUaGlzIG1lc3NhZ2Ugb3JpZ2luYXRlcyBmcm9tIFdIU21pdGggVVNBIFRyYXZl
bFxwYXINClJldGFpbC4gVGhpcyBlbWFpbCBtZXNzYWdlIGFuZCBhbGwgYXR0YWNobWVudHMg
bWF5IGNvbnRhaW4gbGVnYWxseVxwYXINCnByaXZpbGVnZWQgYW5kIGNvbmZpZGVudGlhbCBp
bmZvcm1hdGlvbiBpbnRlbmRlZCBzb2xlbHkgZm9yIHRoZSB1c2Ugb2YgdGhlXHBhcg0KYWRk
cmVzc2VlLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LCB5b3Ugc2hv
dWxkIGltbWVkaWF0ZWx5XHBhcg0Kc3RvcCByZWFkaW5nIHRoaXMgbWVzc2FnZSBhbmQgZGVs
ZXRlIGl0IGZyb20gdGhlIHN5c3RlbS4gQW55IHVuYXV0aG9yaXplZFxwYXINCnJlYWRpbmcs
IGRpc3RyaWJ1dGlvbiwgY29weWluZywgb3Igb3RoZXIgdXNlIG9mIHRoaXMgbWVzc2FnZSBv
ciBpdHNccGFyDQphdHRhY2htZW50cyBpcyBzdHJpY3RseSBwcm9oaWJpdGVkLiBBbGwgcGVy
c29uYWwgbWVzc2FnZXMgZXhwcmVzcyBzb2xlbHkgdGhlXHBhcg0Kc2VuZGVyJ3Mgdmlld3Mg
YW5kIG5vdCB0aG9zZSBvZiBXSFNtaXRoIFVTQSBUcmF2ZWwgUmV0YWlsLiBUaGlzIG1lc3Nh
Z2UgbWF5XHBhcg0Kbm90IGJlIGNvcGllZCBvciBkaXN0cmlidXRlZCB3aXRob3V0IHRoaXMg
ZGlzY2xhaW1lci4iXHBhcg0KXHBhcg0KfQ==

--openmail-part-3d6cae2c-00000002--

Messages In This Thread

• Split Up PSApBTAB dbspace
  Sanjiv K Khiste -- Tuesday, 20 May 2003, at 11:38 p.m.
  • RE: Split Up PSApBTAB dbspace
    John Carlson -- Wednesday, 21 May 2003, at 8:59 a.m.
    • RE: Split Up PSApBTAB dbspace
      NormaJean.Sebastian@tellabs.com -- Wednesday, 21 May 2003, at 10:13 a.m.
    • Re: Split Up PSApBTAB dbspace
      Clifton M. Bean -- Wednesday, 21 May 2003, at 11:39 a.m.
    • RE: Split Up PSApBTAB dbspace
      John Carlson -- Wednesday, 21 May 2003, at 1:40 p.m.
  • Re: Split Up PSApBTAB dbspace
    ESTEBAN RIEZNIK -- Wednesday, 11 June 2003, at 5:20 p.m.
    • RE: Split Up PSApBTAB dbspace
      Rajasekaran, Rajesh -- Monday, 16 June 2003, at 10:04 a.m.
      • Re: RE: Split Up PSApBTAB dbspace
        ESTEBAN RIEZNIK -- Thursday, 19 June 2003, at 5:30 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.