commvault.com commvault.com
Solved

DB2 backup on AIX very slow

Show first post

29 replies

M
Rank
Badge +4

Thanks Mahender, just started a new backup with 18 streams..

I also see below in the db2diag.log:
 

2021-03-14-17.52.37.444843+060 I1331304A1841        LEVEL: Error (OS)
PID     : 15598158             TID : 1              PROC : db2exfmt
INSTANCE: db2prd               NODE : 000           DB   : PRD
APPID   : *LOCAL.db2prd.210314165405
HOSTNAME: lpdd001
EDUID   : 1
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED  : OS, -, open
OSERR   : EACCES (13) "The file access permissions do not allow the specified action."
DATA #1 : String, 111 bytes
A total of 2 analysis will be performed :
 - User info
 - Path access permission

 Target file = /db2exfmt.msg
DATA #2 : String, 188 bytes
  Real user ID of current process       = 1003
  Effective user ID of current process  = 1003
  Real group ID of current process      = 2012
  Effective group ID of current process = 2012
DATA #3 : String, 41 bytes
current sbrk(0) value: 0x0000000113e01900
DATA #4 : String, 209 bytes
Information of each subdirectory leading up to the first inaccessible one is shown in the format below :
   <UID>:<GID>:<permissions> (subdirectories)


 Cannot descend any further than the above subdirectory.
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x090000001F1DBB9C pdOSSeLoggingCallback + 0x448
  [1] 0x09000000096772FC oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1BC
  [2] 0x0900000009677770 ossLogSysRC + 0x70
  [3] 0x090000000969FC3C ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xD7C
  [4] 0x090000001ED256A4 sqloSystemErrorHandler + 0x514
  [5] 0x090000001F200864 sqloopenp + 0xE48
  [6] 0x090000001E89AAFC sqlagf_open_handle__FP12SQLO_FHANDLEPc + 0x84
  [7] 0x090000001E5B9854 sqlaeror__FP5sqlca + 0x108
  [8] 0x090000001E5B837C sqlabndx + 0x208
  [9] 0x090000001EAF54D4 sqlabndx + 0x2E0
  [10] 0x000000010000CD28 main + 0x1CE8
  [11] 0x00000001000002F8 __start + 0x70
 

Not sure which directory is inaccessible..

 

KR,

 

Marcel Huisman

M
Rank
Userlevel 3
Badge +5

@Marcel Huisman It appears 30% of the backup time was waiting on a free buffer(MsgQ).
You may need to increase the backup streams and see how that helps.
You could double the streams from 9 to 18 as the parallelism and buffers are already set to a higher value(40)

Ref link - http://www.redbooks.ibm.com/abstracts/tips1344.html?Open

M
Rank
Badge +4

Hi Sunil,

See attached log file,

 

Thanks in advance,

 

Marcel Huisman

 

 

1 Attachment
Sunil
Rank
Userlevel 5
Badge +13

Hi Marcel,

Can you get the performance statistics from db2sbt.log on the DB2 server? This log will be in the Commvault log directory.

 

Thanks,

Sunil

Reply


Terms & ConditionsCookie settings