Our vBulletin migration is complete.
Welcome vBulletin users! All content and user information from the Micro Focus Forums (vBulletin) site has been migrated to this site. READ MORE.
Absent Member.. RaajK Absent Member..
Absent Member..
1956 views

DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Hi Folks,

 

I am getting below error on IDB, could not find any help in the support docs on extension of "pos.dat' .

Any early  help will he appriciated.

 

DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

0 Likes
1 Solution

Accepted Solutions
Absent Member.. RaajK Absent Member..
Absent Member..

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Hi Bob,

Thanks!

It was not allowing to extend pos.dat beyond 8GB, therefore logged a support ticket and we received a patch to extend it up to 12 GB and it allowed us to extend  pos.dat

 

Thanks! I appreciate your help.

0 Likes
10 Replies
Knowledge Partner
Knowledge Partner

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Hi,

 

Post output  for :

omnidbuitl -info

and

omnidbutil -extendinfo

 

Regards

Please assign a kudo to this post, if you find it useful.
0 Likes
Absent Member.. RaajK Absent Member..
Absent Member..

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Hello,

 

I am still facing the issue. The operations guide says that :

Note : Not all tablespaces can be extended from the GUI/CLI, like pos.dat or overs.dat. In case of issues, contact HP support.

 

0 Likes
Bob_Clark Absent Member.
Absent Member.

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

To thoroughly evaluate this, we would need to know what version of Data Protector you are using, and what is the OS-type and version of your cell manager

 

You should stop Data Protector and make a copy of 'db40' before attempting any of this

 

I would recommend that you do a purge of your Internal DataBase first

 

UNIX-based Cell Manager

=============

 

                 cd /opt/omni/sbin

                 ./omnidbutil -purge -filesnames -force

                 ./omnidbutil -purge -mpos -force

then, follow the instructions in the attachment "db_purge_unix" 

Windows-based Cell Manager

=============

 

From the MS-DOS prompt

             cd \Program Files\Omniback\bin

                omnidbutil -purge -filesnames -force

                omnidbutil -purge -mpos -force

then, follow the instructions in the attachment "db_purge_windows" 

This may fix the problem, if not we have to look into Extending the Tablespace from the command line

0 Likes
Highlighted
Absent Member.. RaajK Absent Member..
Absent Member..

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Hi BOB,

 

Thanks for your reply. We are doing puring regularly on weekly basis (including purging mpos), also tried read DB and Write DB as well, however the issue still persists.

 

Please find the required infomation as below:

Cell Manager OS: HP-UX bkpph006 B.11.23 U ia64 0399047515 unlimited-user license - HP 11

DP Version :6.21

 

Patches:

Patch level         Patch description
===========================================
PHSS_43297/DPSOL_00507/DPLNX_00231 Core Component
PHSS_43297/DPSOL_00507/DPLNX_00231 Core of Integrations component
PHSS_43422          Cell Manager Component
PHSS_43298/DPSOL_00508/DPLNX_00232 Disk Agent
PHSS_43299/DPSOL_00509/DPLNX_00233 Media Agent
PHSS_43144/DPSOL_00503/DPLNX_00223 User Interface
PHSS_42607/DPSOL_00469/DPLNX_00175(b621) Java User Interface
PHSS_42609/DPSOL_00471/DPLNX_00177(b621) HP P9000 XP Agent
PHSS_43238/DPSOL_00506/DPLNX_00229 English Documentation (Guides, Help)
QCCR2A43469_TM1 rsm.Oracle_Dev_Rest_new Test Binary
QCCR2A35552_TM1 rsm.orig1 Test Binary
QCCR2A35552_TM1 rsm.orig3 Test Binary
QCCR2A35552_TM1 rsm.patch_Orig Test Binary
QCIM2A47356_IM omnidbutil Test Binary
QCIM2A47356_IM omnidbutil.patch_pos_key_increase Test Binary
QCCR2A44256_TM2 libob2ecmn.so Test Binary
QCIM2A38768_IM4 libob2ecmn.so.DB_Corruption Test Binary
QCCR2A34241_TM2 libob2ecmn.so.patch Test Binary
QCCR2A44256_TM2 libob2ecmn.so.splitObjectsToBrowse_DP6.21 Test Binary
QCCR2A44256_TM1 libob2ecmn.so.splitObjectsToBrowse_new Test Binary
Number of patches found: 20.

 

Could you please advise if pos.dat can be extended further if yes how , and if  not whats the work around ?

Thanks in advance for all your help.

 

Regards

0 Likes
Bob_Clark Absent Member.
Absent Member.

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Please be sure that, before doing any of this, you have stopped Data Protector, and made a copy of

 

           /var/opt/omni/server/db40

 

None of this is documented.  You may want to just go ahead and open a case with the Response Center, if it doesn't work, I would advise that regardless

 

Edit the file

 

        /etc/opt/omni/server/options/global

 

to add the lines

 

          DbPosDatLimit=8

          DbPosKeyLimit=8

 

Save the file, restart Data Protector, run the command

 

         cd /opt/omni/sbin

         ./omnidbutil -extendtblspace pos.key /var/opt/omni/server/db40/datafiles/cdb/ -max size 2047

         ./omnidbutil -extendtblspace pos.dat /var/opt/omni/server/db40/datafiles/cdb/ -max size 2047

 

You can try running this again

 

        ./omnidbutil -extinfo

 

to see if a 'pos.dat' or a 'pos.key'shows up, but, I doubt if it will

 

If this gives you an error, stop Data Protector, remove or rename 'db40', and put the copy back into place.  Then, open a case (if you have not already done so) with the DP Support team

Absent Member.. RaajK Absent Member..
Absent Member..

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Hi Bob,

Thanks!

It was not allowing to extend pos.dat beyond 8GB, therefore logged a support ticket and we received a patch to extend it up to 12 GB and it allowed us to extend  pos.dat

 

Thanks! I appreciate your help.

0 Likes
Ken Krubsack Absent Member.
Absent Member.

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Bob,

 

For my own education, what is the function of the pos.dat database in DP?

 

Thanks

Ken

0 Likes
Bob_Clark Absent Member.
Absent Member.

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Hi Ken

 

  I conversed with a member of Engineering specializing in IDB issues, and here is his response

 

It is tape position data of objects (filenames) and the pointers to associated data.

 

That is the short answer.

 

The difference between dat and key are pointers to file versions, and object versions. Files, objects (dat) and key (file and page keys).

Ken Krubsack Absent Member.
Absent Member.

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Bob,

 

OK... so that means that the -fixmpos option on omnidbutil cleans up that database set.... right?

 

Just putting more pieces of the puzzle together between my ears.

 

Thanks

Ken

0 Likes
Absent Member.. RaajK Absent Member..
Absent Member..

Re: DbTablespaceLow "[138:717] Tablespace "pos.dat" is running out of space

Jump to solution

Hi,

It establishes consistency between media positions (mpos) and binary files.

 

Following  is the suggestion from IDB Purge best practices. 

 

omnidbutil -purge –dcbf, deletes the dcbf records that are no longer required. However, the mmdb will still have mpos records referring to these removed dcbf records. Therefore, from time to time we suggest the consecutive running of a dcbf Purge followed by a fixmpos.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.