Formatting SQL select statement output
Formatting SQL select statement output How do I change the output of the column width in a select statement? Below is a select statement I am currently working on and would like to expand the message column to something wider than the default 18 chr. Dave T ADSM Version 3 Release 1 Level 2.3 select date_time as "Date and Time", message from actlog where msgno=1210 and cast((current_timestamp-date_time)days as decimal(12,0))<1 and substr(message, 41, 7)='SRVTAPE' or (msgno=0986 and cast((current_timestamp-date_time)days as decimal(12,0))<1 and substr(message, 18, 2)=(select substr(message, 97, 2) from actlog where msgno=1210 and cast((current_timestamp-date_time)days as decimal(12,0))<1 and substr(message, 41, 7)='SRVTAPE')) Date and Time MESSAGE -- -- 2000-09-14 ANR1210I Backup of 02:00:17.00 primary storage pool SRVTAPE to copy storage pool OFFSITE started as process 81. 2000-09-14 ANR0986I Process 02:35:00.00 81 for BACKUP STORAGE POOL running in the BACKGROUND processed 1045 items for a total of 10,893,062,729 bytes with a completion state of SUCCESS at 02:35:00.
Re: I HATE THIS ! ! !
Running a second session of DSMADMC.EXE -console with the console option will eliminate the need for a lot of Q PR's -Original Message- From: Cook, Dwight E [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 10, 2000 7:30 AM To: [EMAIL PROTECTED] Subject: I HATE THIS ! ! ! Ok, how many people in their typing don't hit the "q" key hard enough and rather than a "q pr" they issue a "pr" and the #@$%^ PREPARE initiates ! ! ! sorry about that, I'll go take my thorazine now... Dwight
Re: Off-Site copies??
Yes. Coping from diskpool to an offsite tape pool works and works well on systems with few tape drives. With only one tape drive there is one concerns. Diskpool migration can not start before the offsite copy. If it does, the data migrated to tape will not be available on the diskpool for the offsite tapes. I am going to assume there is a way to move the previous migrated data back to the diskpool, but that is beyond my abilities. Dave T -Original Message- From: Michael Hose (GIS) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 1:58 PM To: [EMAIL PROTECTED] Subject: Off-Site copies?? how to generate Off-Site Copies off the entire TSM-Client Content whith just one drive? we backup all clients during the night to the TSM Disk-Storage Pool which will later the day migrated to the Tape Storage Pool. The question is, can I with a "Backup Stgpool Diskpool Offsitepool" (Offsitepool is a Tape Storage Pool) before the data is being migrated, backup the complete Content of the clients(at least for active Versions)? Does TSM keep track of the valid data in the offsitepool so that I can manage the export und import of tapes to Offsite-Location? has anybody tried something like this before? thank for any help Mit freundlichen Grüßen / best regards Michael Hose [EMAIL PROTECTED] GIS Gesellschaft fuer InformationsSysteme mbH Hans-Boeckler-Str. 20 30851 Langenhagen Tel. +49 511-78643-0 Fax -99 IBM/Lotus Qualified Partner AT&T Global Network Services Partner http://www.gish.de
Internal error BUF011 detected
How serious is this error? Everything appeared normal after restarting the ADSM server. Dave T 11/02/2000 07:09:45 ANR0207E Page address mismatch detected on database volume G:\DB\VOL04-PRI.DSM, logical page 1702913 (physical page 130305); actual: 0. 11/02/2000 07:09:45 ANR0207E Page address mismatch detected on database volume G:\DBMIR\VOL04-MIR.DSM, logical page 1702913 (physical page 130305); actual: 0. 11/02/2000 07:09:45 ANR0248E Unable to read database page 1702913 from any alternate copy. 11/02/2000 07:09:45 ANR7838S Server operation terminated. 11/02/2000 07:09:45 ANR7837S Internal error BUF011 detected. 11/02/2000 07:09:45 ANR7833I Thread 1 (tid 271) terminated in response to program abort. 11/02/2000 07:09:45 ANR7833I Thread 2 (tid 298) terminated in response to program abort.
Re: Internal error BUF011 detected
Thank You I'm sure that's it. The previous command was a "select status, count(*) as "Tape Count" from libvolumes where LIBRARY_NAME = 'LIB3' group by status", and we are running a older version here. Dave T -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 02, 2000 8:35 AM To: [EMAIL PROTECTED] Subject: Re: Internal error BUF011 detected You didn't tell us your server level, but this might be the "select ... group by" problem (APAR IY07006) fixed in 3.7.
Re: Exchange Agent Scheduler
When the Exchange agent is installed it replaces the old adsmv3.dll (566KB ) with its adsmv3.dll ( 472KB ). With this dll in place dsmcutil errors out. If you place the old adsmv3.dll back in the system32 directory, the dsmcutil will work. Dave T -Original Message- From: Del Hoobler [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 6:23 AM To: [EMAIL PROTECTED] Subject: Re: Exchange Agent Scheduler Bill, Is DSMCUTIL failing with that error? If I recall this might be an issue with a mix-match in the installed TSM API version vs. the base client (DSMCUTIL) version. You may have to get a 3.1.0.8 version of the adsmv3.dll and put it into the directory with DSMCUTIL.EXE. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] "Mayo, Bill" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 11/17/2000 06:04:56 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Exchange Agent Scheduler I have installed the Exchange Agent on our mail server with the newest version (1.1.1.01) and have been able to successfully do manual backups. The problem that I am having is that I cannot get the additional scheduler service loaded. When I try to install it I get the following error message: "The ordinal 28 could not be located in the dynamic link library adsmv3.dll" This is on Windows NT 4.0 SP 5, Exchange Server 5.5 SP2, and ADSM Client 3.1.08. I would appreciate getting a direct cc: to any replies as I get the digest version. Thanks for any help you can provide! ~~~ Bill Mayo Network Administrator Pitt County MIS
Re: Novell restore prob: unable to allocate directory handle?
Unable to allocate directory handle is just Novell way of saying you don't have rights to do that. Most likely cause, smdr.nlm has a bad copy of the DS Exit out of any dsmc.nlm that is running unload dsmcad unload tsands unload tsa500 unload smdr load smdr load tsa500 load tsands load sys:adsm\dsmc sched load sys:adsm\dsmc load sys:adsm\dsmcad Dave T -Original Message- From: Mike Chang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 29, 2000 8:54 AM To: [EMAIL PROTECTED] Subject: Novell restore prob: unable to allocate directory handle? ZoomerangSituation: - Netware 5.1 server - TSM client 4.1 - ADSM os390 3.7 - TSA500 v5.03 when trying to restore VOL1 we get the error listed in the subject field. Does anyone know of a work around? I definatly thinks its a SMS or TSA problemany ideas? Mike Michael Chang Senior Network Engineer Vertis, Inc. 215.997.5226 [EMAIL PROTECTED]
Re: NetWare Client abends
If you do not need the Macintosh file space, remove it with vrepair. That file space doubles the NetWare directory space needed and it has caused similar problem for us. Dave T -Original Message- From: David Longo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 20, 2000 9:11 AM To: [EMAIL PROTECTED] Subject: Netware Client abends We have the following config: TSM Server 3.7.4.0 on AIX 4.3.3 Netware Client 4.1.0.0 on Netware 5.0 SP5 Hardware: IBM Netfinity 7000, model 8651-RM0 768 MB RAM IBM ServeRAID II, 6 - 9GB HD's, RAID5 w/HS We Use TCPIP commmethod. Partial output of VOLUME command: Mounted Volumes Name Spaces Flags SYS DOS, LONG Cp Sa VOL1 DOS, MAC, NFS, LONG NSS This client was on 3.7.2.11 of TSM and had the same problem. Doing an INC backup on a daily prompted schedule it will abend about every 2nd or 3rd day. Below is one of the Abend log entries. The abend is always the same. I am fairly new here and have started working out existing problems, like this one. This Client is working as a file server. It is backing up VOL1:/users when it abends. It appears to always to abend in the S or T area (User names alphabetically). At this point it has examined about 400,000 files. I did a SEL backup with just one users directory that seemd to have a problem. It abended after about 7,000 files as follows: ?--- --- Normal File - 10,278,912 VOL1:/Users/TSANDERS/remdrept/RemedyLinkForPalm/Setup/Remedy/PalmLink/aix/re mlink.tar [Sent] (TSA500.NLM 5.3 313) A file cannot be read. ?--- - I then did a SEL narrowing directory path smaller and it worked without error. I did search of Tivoli Knowledge Base on TSA500 and several other searches and one TSA500 entry was sort of like ours but solution we have already implemented. A disk scan has been done by our Netware Admin and had no problem. We have other Netware boxes with 3.1 amd 3.7 clients and they work without error. Anyone have any ideas/suggestions? ABEND LOG *** Server HFIT halted Friday, December 8, 2000 10:54:37 pm Abend 1 on P00: Server-5.00i: Page Fault Processor Exception (Error code ) Registers: CS = 0008 DS = 0010 ES = 0010 FS = 0010 GS = 0010 SS = 0010 EAX = EBX = C83E87D4 ECX = 0003 EDX = C83E8900 ESI = C83E894C EDI = EBP = C83E87D0 ESP = C83E86C4 EIP = D17FB830 FLAGS = 00014256 D17FB830 8B4058 MOV EAX,[EAX+58]=? EIP in FILESYS.NLM at code start +0004B830h Access Location: 0x0058 The violation occurred while processing the following instruction: D17FB830 8B4058 MOV EAX,[EAX+58] D17FB833 81E1FF00 AND ECX,00FF - End of file. [SYS:SYSTEM\ABEND.LOG] * David B. Longo Systems Administrator Health First, Inc. I/T 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5525 [EMAIL PROTECTED]