View Full Version : db2 answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21 22

  1. Year, Month, Day functions
  2. db2_all
  3. Named Pipes Problem
  4. Setting nulls in Development Center for SQL Functions
  5. DB2 V8 Client / DB2 for z/OS Upgrade Path
  6. Running the same script across multiple DB2 databases, instances and servers
  7. can't create database cause access failure in db2spcat
  8. MS-DTC and .Net client doesn't work with Transaction Required
  9. Unable to select from temporary tables
  10. DB2 SQL Formatting
  11. Problem with Rebuild Index after loading data with DSN1COPY
  12. Handling Special character in openquery
  13. Problems with national characters
  14. SQL PL online manual/guide?
  15. Last Chance for VDC Embedded Database Survey - Takes Less Than 5 minutes...
  16. Last Chance for VDC Embedded Database Survey - Takes Less Than 5 minutes...
  17. DB2 UDB Security
  18. access pseries DB2 from iseries using COBOL and RPG
  19. Apply Program Not Moving Data
  20. db2_awe and more than 4GB memory on Windows
  21. NAS for DB2 active logs
  22. MDC Rollout
  23. Shameless self-promotion
  24. Oracle DBA Inherited DB2 System
  25. Trigger Failure Cancels calling transaction
  26. Performance of union all views
  27. Why does the execution plan hav a nested loop join when an UDF is used?
  28. SQL Procedure Question
  29. Embedded Database Research
  30. Where are the downloadable versions of the V8 manuals?
  31. Sybase to UDB Migration - Code Freeze
  32. Update Fails with SQL0407N
  33. sql replication script
  34. problem while index creation
  35. DB2 replication - Apply program not replicating
  36. Error in nested SQL Procedure
  37. SQL Statement length exceeded
  38. compact and compress?
  39. SET CURRENT LOCK TIMEOUT
  40. materialze query?
  41. Putting Information Center on hard drive
  42. 64-bit platform support for XML Extender
  43. Can I store binaries outside /sqllib/function?
  44. clob question.
  45. Get the DB2 version number through SQL (onMVS)
  46. How I can get statistics by indexes using?
  47. Packagename of a routine
  48. Change Server Name on a DB2 Server
  49. drop table/recover space
  50. Can I replicate data between a pair of databases in the same instance?
  51. Stored Procedures (db2dari.exe) sucking up memory
  52. Does DB2 WSUE supports 64 bit computing ?
  53. DIA3819C A file sharing violation has occurred, filename was ""
  54. UDB V8 FP9a "log data" monitor elements
  55. Cannot connect to db2 using jdbc
  56. Statement sequence in SQL Stored Procedure
  57. retrieving clobs over wan
  58. UDB V8 (Fixpak8) - "Database files closed" monitor element
  59. Why are the "same" queries optimised differently ?
  60. DBA2052E
  61. Db2 help needed
  62. DB2 V8 - user account TROUBLE
  63. DB2 port
  64. using jdbc to connect to db2
  65. Difference between a 'file' and a 'table'
  66. load utility does not work from control center
  67. Char in US Code page vs Char in UTF-8
  68. problem with unloading data from DB2 ver7
  69. problem with unloading data from DB2 ver7
  70. DB2 and PHP
  71. No future for DB2
  72. Vargraphic not available in GUI
  73. Prevent Infinite Looping in Q Replication
  74. Help! Call sql procedure - SQL1109N The specified DLL "SYSIBM.SQLPROCEDURECOLS
  75. show comments for columns ...
  76. solution on source code page "1114" to the target code page "UNKNOWN".
  77. Merge stmt
  78. Design Advisor does not recommend indexes !!
  79. UDb V8.FP6 - Finding NEXTVAL for IDENTITY COLUMN (not SEQUENCE)
  80. Reorg of very large tables
  81. UDB V8.2 (FP1) - DGTT WITH REPLACE vs. delete * from DGTT
  82. HADR / Q replication comparison
  83. Trying to get scrollable result set from SQL stored procedure
  84. commands to copy archived logs in disk to tsm
  85. DB2/390 v8 - union all subquery in select list returns wrong results
  86. Inner Joins and UDFs
  87. how to archive logs to disk and then use tsm to back them up to tape
  88. Table function GET_DBM_CONFIG missing in Fixpak 9
  89. How to Stop a Database
  90. DB2 AS400 convert character to date format
  91. DB2 AS400 convert character to date format
  92. unable to install SQL Express 2005 CTP
  93. overflows : interpretation
  94. DB2 Event Monitor puts "?" for all the values
  95. Help to compile C UDFs using gcc on AIX (bldrtn)
  96. Table size estimation
  97. Copying my DB2 database connections
  98. Need FixPack 7a urgently. Plz. Help!
  99. DB2 v8 --- Creating the DB2CERT database...
  100. DB2 v8
  101. DB2 replication setup step by step
  102. Help with "SQL30081N A communication error has been detected"
  103. DB2 and cygwin ...
  104. resetting monitoring switches
  105. Cursors defined as "WITH HOLD" are closed after commit.
  106. MQT/Staging Table/Syntax
  107. Division by Zero or changed order of applying predicates in SQL
  108. q replication/sql replication
  109. Pick until enough
  110. very strange ... SQL0910
  111. Modification time
  112. SQLSTATE 42997
  113. DB2 Replication - synchtime
  114. How do I increase the size of the output message parameter of a debugger
  115. SQL0270 RC 73
  116. HADR Questions
  117. DB2 solaris installation without open windows?
  118. DB2 Warehouse Site Agent!!
  119. privileges on packages - db2 8.2.2
  120. Journal - Task History - Database backup success is expired
  121. [Restore DB] backup from linux & resotore to windows
  122. Can we create an alias for a sequence in db2
  123. error : DIA3207E L'appel TCP/IP "gethostbyname"
  124. Will the new RECOVER Command run in parallel on a partitioned database ?
  125. DB2 migration v5 to v8.1
  126. Change a table's tablespace
  127. DB2 V8.2 FOR LINUX - REXX STORED PROCEDURE
  128. db2advis - Disk Limit Constraint
  129. TPC-H Query Results - 1GB DB
  130. Problem running control center.
  131. UDB 8.2 poerformance problem
  132. How to DELETE with COMMIT COUNT
  133. DB2 Before Insert Trigger not acting like before?
  134. SQL Problem - Date / Txn Sequences
  135. Bogus data type incompatible error SQLSTATE=22001?
  136. Select column user via clp without getting token user
  137. Can CLP output be timestamped?
  138. Problems with Java SPs on Win2003 server
  139. SQL0289 when Alter table space
  140. db2spmrsy
  141. Question about VARCHAR Vs. CHAR fields
  142. DB2 8.1 32-bit Linux migration to 8.2 64-bit on AIX
  143. Delete vs. Merge
  144. DB2 Connect V8, Schema functions, and CLI driver
  145. Materialized Query Syntax--I can't get the samples to work
  146. Problems with connection pool for DB2400
  147. Question on Package Cache Overflows
  148. db2move questions
  149. db2move questions
  150. temporary tablespace without sufficient page for replication
  151. SQL UDF works very strange. Bug or feature?
  152. Same software, different hardware and abominable performance
  153. replication scheduling
  154. Migration path -> Unidata V6 to DB2 V8.2
  155. Any Info to join the "Serrano" Beta for the Next Websphere Information Integrator?
  156. Nickname in two phase commit ???
  157. Nickname in two phase commit ????
  158. -22205 return code from task center
  159. APAR IY66088
  160. Windows authentication on DB2 UDB 8
  161. Test Post - Ignoe
  162. DB2 Views
  163. Isolation question for DB2 beginer
  164. DB2/UDB B-Tree Indexing, Reverse Scans
  165. Call a View over SQL (DB2 UDB V8.1.6)
  166. using nextval in external udf
  167. UNION ALL View
  168. Stripe sets, high watermark and restores
  169. export package
  170. join 2 databases
  171. DB2 & System Dates
  172. DB2 Client on SUSE 9.3?
  173. Triggers - can I have it fire only if certain columns actually change?
  174. Raw Device Wiggle Room?
  175. read only standby db
  176. SQL Abfrage auf DB2 UDB V 8.1.6
  177. Problem with UDF
  178. Migrating Application SErver with DB server
  179. DB2 HADR 8.2.2 for REORG maintenance
  180. Database lost - Help me
  181. Database lost - Help me
  182. locate and select
  183. Database lost - Help me
  184. Confused over data page utilization
  185. Unexpectend end of ZLIB input stream ???
  186. split mirror : high availability
  187. db2move problem
  188. Problem with sqlp_AsyncLogReadAPI, generating error every 2 second
  189. Scope problem? UDB DB2 R8.1.5 Linux
  190. result set is closed
  191. Handling Money Via UDT / UDF (i.e. homegrown "extender")
  192. Oracle Transparent Gateway
  193. How large of a bufferpool can you create?
  194. Message being sent to port 523 (DAS)
  195. PRUNE Logfile Command Question
  196. Days/date redux UDB DB2 8.1.5 Linux
  197. HADR works with Peoplesoft (JDEdwards)
  198. Password Settings
  199. some problems with the replication
  200. Cleaning up after a crash
  201. Problem Upgrading to FP9a Using Alternate Fixpack
  202. update db cfg dbheap
  203. SQL0567N
  204. Fixpack 9a now available
  205. Index / Primary Key
  206. Transaction Log Full and Stored Procedure
  207. Redirected restore problem
  208. DB2 Connect Problem
  209. backup
  210. JCL or CICS from store procedure
  211. Search multiple job sites for you!
  212. Problem with SQLFreeStmt
  213. backup image compatibility between different versions
  214. windows executable error - db2
  215. Db2 select statment
  216. Different NUMBLOCKPAGES across Partitions (DPF)?
  217. problem with db2 authentification
  218. Passing And ARRAY to a Stored Procedure
  219. Problems with Type 4 jdbc driver
  220. Consultant Needed
  221. Best Practices for Copying of Data Between Instances
  222. file versus command line issue
  223. How to extract a list of top running queries on a database on a single day
  224. Poor insert performance
  225. Tempspace only one container is being used - EEE!
  226. how to update sqlj routine source in catalogs ?
  227. Invalid arg exception when connecting to db w/underscore in name
  228. convert duration in seconds to hh:mm:ss
  229. Activate db - command changed in 8.x?
  230. abysmal performance with scalar query
  231. Program querying DAS for isntances/databases
  232. How to pad a sequence value with zeros
  233. Emergency question about SQL0818 gotten on SQLJ proc
  234. converting existing DB2 v8.1.1.72 AIX 5.2 to 64-bit. Need info please.
  235. Database size
  236. Prove HADR
  237. db2 store procedure-- sqlstate=38503
  238. jdbc connection crashing database
  239. Union Problem
  240. Moving database to a larger hard disk partition
  241. DB2 Managed Service Provider
  242. script to restore db from comand line
  243. Change passwd programatically?
  244. Last commited transaction less then backup image timestamp after restore with rollforward?
  245. Moving home directory on DB2 instance?
  246. HIS 2000 connectivity problem
  247. replication
  248. db2 AIV extenders for Linux
  249. problem with a binary (maybe)
  250. installing db2 8.2.2 on RHEL4
  251. How to use cygwin xterm and db2
  252. SQLSTATE: 23505 UDB DB2 8.1.5
  253. Backup Options
  254. DB2 in production environment.
  255. Schema Mapping
  256. Connection to iSeries with Windows credentials requires Local Admin rights
  257. Tools to convert Mysql DDL to DB2
  258. AppDetective and DB2 instances
  259. Federated Insert and local update in on transaction not possible
  260. decimal to char problems
  261. Libeay32.dll conflict
  262. Make DB2 administrative APIs available through SQL
  263. DB2 Everyplace problems
  264. File System Full
  265. RTRIM is not truncating trailing spaces at the end of the line
  266. files under db2dump
  267. Replication Center SQL Replication Subscription sets
  268. User password?
  269. Seek DB2 translation of complicated Oracle join statment
  270. DGTT Changes access plan (extra SORT + RIDSCAN)
  271. Accessing old IBM DB2 V5.2
  272. restore db2 backup with include logs
  273. ODBC Driver
  274. Decomposing XML
  275. ONLINE REORG
  276. DB2 Archive Failure
  277. Workload/Query Generator
  278. Execute multiple statements in a Procedure
  279. Backup Question
  280. db2advis - works with indexes but not MV
  281. Status codes from Various UDB Utilities
  282. Automatic table maintenance
  283. Pivot or Invert row data
  284. Restore catch 22 db2 udb 8.1.5
  285. DB2/UDB and Read Locks
  286. DBexpress with DB2 questions
  287. Max number of Cursors?
  288. SQL30020N Execution failed because of a Distributed Protocol Error
  289. Cannot create sample database
  290. Date format db2 udb
  291. Where do I find out more?
  292. What is the difference between workgroup server and enterprise server edition?
  293. DSNTIJMS job in DB2 for z/OS
  294. Get human-readable error meesages ala db2 ? sql00911
  295. Number to Time Conversion
  296. No error messages from bind
  297. SMTP refuse email <instance>@<host>
  298. Structured type
  299. CONNECT TO hangs, no response
  300. How to detect running under RRSAF or CAF?
  301. Size of "Indexes and Materialized Views"
  302. Seek DB2 translation of Oracle statement with date stuff
  303. performance & behaviour question
  304. Lost active log, can't connect to database..
  305. db2v81 PE inst on gentoo(linux),amd64
  306. HADR primary connection failure tryin to communite to standby
  307. Empty Query Cache
  308. Warehouse Manager Agent problem
  309. * Need help on Backup *
  310. use dynamic SQL in external user-defined table function
  311. Monitoring And Maintenance
  312. Position open to fill - embarking on Data Warehouse project
  313. problem with a restore maybe ...
  314. DSNU255I in a LOAD LOG NO RESUME YES
  315. Corrupted download files for DB2 8.2 PE Linux 2.6
  316. MQSEND on z/OS and DB2
  317. Other memory
  318. Help Product Information - Information Integrator for SyBase to UDB Migration
  319. SQL - Unexpected Token "date/interval"
  320. OFF TOPIC: x86 Server Selection
  321. db2diag.log error
  322. generate row number in result set?
  323. Dates not in the future
  324. Query Execution Time
  325. >255 chars into stored procedure via ado
  326. Latest stable version?
  327. Transferrate / overhead
  328. -101 on alter table statement
  329. Restoring from a crashed system.
  330. URGENT:Exporting and Importing data using IXF format
  331. question about online backups
  332. Problem with updates via MS Access
  333. logfile on db2
  334. Can I customize DB2 catalog with my own tables?
  335. SQL0206N "C" is not valid in the context where it is used. SQLSTATE=42703
  336. Information Integrator - AIX ODBC - any user experiences?
  337. Question on dropping a trigger
  338. Library issue
  339. No Subject
  340. problem with different access plan (slow & fast) for the same SQL-Statement
  341. Code in the database or middle tier (the CLR controversy)
  342. db2pgixt
  343. log_retain_status and logarchmeth1
  344. Problem with federated database
  345. I am a new user help needed
  346. Problem with a query with MAX function
  347. why I can't display a jpg Blob field in web?
  348. SAR file -- can this be imported and edited?
  349. SQL-to-XML error when calling dxxgenx
  350. way to speed-up/tune database creation?
  351. Database market share 2004
  352. db2 backup issue on windows
  353. SQL10007N Message "-1390" could not be retrieved. Reason code: "6".
  354. haven't got a clue on this error.
  355. Unable to restart DB2 Instance
  356. A SOLUTION FOR ASP.NET DEVELOPERS USING DB2
  357. Run-Time Clients
  358. customize CREATE DATABASE
  359. URGENT:Anybody out there with DB2 6.1 SDK for windows
  360. URGENT:Anybody out there with DB2 6.1 SDK for windows??
  361. SQL0270N How to create Java UDF with SQL?
  362. ERROR when using get db cfg command
  363. SQL0950N error
  364. SQL0518N
  365. Unlocking DB2 table/row locks
  366. reorgchk reorg interpretation
  367. SQL0973N QUERY_HEAP_SZ to small
  368. Date format question
  369. Query syntax
  370. Query question
  371. Importing from DEL file where a column value begins with a " ?
  372. Could not build query
  373. Hardware Planing..
  374. How to make a Query with diffrent variables, beeing empty or not?
  375. DB2 8.2 JDBC Application --> CHARACTER and CHAR
  376. increase cpu usage for a db2 process
  377. Importing V8.2 IXF files into V5.2
  378. where to find V7 release ?
  379. Automatic Storage
  380. unable to connect to a db2 server through the control center ... - Help !
  381. db2/UDB replication problems (maybe ...?) - Help needed
  382. Test
  383. Extender server problems
  384. Replication Cold Start
  385. Production Support Analyst Needed
  386. Matching IP Address to subnets.
  387. Net View Ext & BLOBs
  388. Connections
  389. NetApp Filer
  390. Vennela Technologies Offering Beautiful Courses On Oracle
  391. Insert CLOB / BLOB
  392. Loading datetime values from SYBASE into DATE type in DB2
  393. DB2 restores with Veritas NetBackup?
  394. Where can I find what type of field DB2 has
  395. JDBC issues with setBinaryStream an AbstractMethodError and a cast
  396. Calling a DB/2 v8.2 stored procedure from perl
  397. Supra to DB2 migration
  398. cannot connect from Crystal Reports to remote DB2
  399. 8.2.2. Windows "net stop db2-0" with activated databases does not work
  400. looking for not JAVA admin tools for UDB V8
  401. DB2 Stored Procedures called from REXX
  402. Login to AS400 from SQL Data Transformation Services
  403. 8.2 Windows: Health Monitor not always work
  404. CLI0112E Error in assignment
  405. Coding Standard for developing Stored Procedures
  406. SQL0444N Routine "DB2XML.CONTENT"
  407. need header values
  408. Db2 v 8 is buggy
  409. Code page problem: workaround
  410. Where to find FP9 for Linux with kernel 2.6?
  411. Optimization level in db2?
  412. Error: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=S1010 while using ADO
  413. copy database structure
  414. compact lob data?
  415. Problem connecting from AIX to Windows.
  416. PDE 8.2.2 untar problems
  417. federated databases on 2 instances
  418. Transaction log full
  419. Comparison of Performance of SQL and external Procedures
  420. Doc Fixpack 9 for V8 ?
  421. URGENT! trouble with char conversion from nickname
  422. iSeries DB 2 to UDB2 V8.1
  423. a query at db2
  424. unload data
  425. String data right truncation. SQLSTATE=22001
  426. unable to load DLL 'db2app.dll'
  427. Allocation error when allocating memry to CLOB host variables
  428. ROLLFORWARD QUESTION
  429. relation_data_serv problem
  430. sqldEscalateLocks and performances
  431. Stored Procedure - Handling all error code with a single condition !!
  432. Problems with code page
  433. the USER
  434. I think to have a problema with DB2_SQLROUTINE_COMPILE_COMMAND
  435. Install DB2 in an FSIOP/IxS Card in an iSeries
  436. JAVA udf 8.2.2
  437. SQL Stored Proc - Security issue
  438. creating dsn for mainframe db2
  439. New Registry Variables in 8.2.2 (FP9)
  440. HELP ME problem with *.sqc
  441. Handling Time Stamps
  442. No system temporary table space and a SQL query
  443. Deadlock or Timeout when delete/update rows with BLOB
  444. Restoring Journals on an iSeries Box
  445. method to write to a flat file from Stored procedure
  446. HELP! Variable looses value in loop within trigger
  447. get snapshot for dynamic sql
  448. Strange or normal IDENTITY behavior?
  449. DB2 V8.2.2 Manuals (FP9)
  450. Seek equivalent of Oracle's empty_clob() for CLOB creation
  451. Equivalent of Oracle's DBMS_LOB.GETLENGTH(COLUMN_NAME)
  452. Enabling database for DB2IMAGE
  453. Strange inconsistences when repeating a query more than twice in a row
  454. Strange inconsistences when repeating a query more than twice in a row
  455. Is there a "go to" statement in DB2 Stored Procs.
  456. viewing privileges for stored procedures
  457. Aggregating text
  458. Trigger syntax ? problem
  459. multilanguage problem
  460. connecting to remote 7.1 db2 database
  461. Equivalent of Oracle's to_date('03/04/2005','MM/DD/YYYY')
  462. Comparing dates using date function and arithmetic
  463. db2LogRead API Error
  464. how to print a new line character
  465. Control Center lock
  466. accent insensitive diacritic insensitive data retrieval
  467. custom collating sequence
  468. generated column
  469. Stored procedures in SYSPROC schema
  470. primary =/=> unique?
  471. FP9 / can't find Apar GG04517
  472. FP9 installer breaks Information Center (Windows)
  473. Using LOWER function in DB2
  474. db2app.dll
  475. Creating Dataset from DataAdapter VS.Studio.NET & Db2
  476. db2 concurrency control question
  477. DB2 equivalent of Oracle to_char(created_date,'MM/DD/YYYY')
  478. How to define this kinds of constraint.
  479. Accessing Oracle from DB2 Stored Procedure
  480. Shameles self-promotion
  481. problems with UNION
  482. changing password
  483. unloading data from db2 v6 tables to os390
  484. Queston on DB2 lock
  485. SQL Stored Procedures X Java Stored Procedures in DB2 8.2
  486. Problem with sequence in UDB 8.2
  487. data warehouse
  488. DIA0001E An internal error occurred. Report the following error code : "ZRC=0x8136001C".
  489. SELECTing from multiple databases?
  490. Performance: CAF vs RRSAF
  491. Password invalid, when logging on as db2inst1 with a password
  492. SYSPROC.ENV_GET_INST_INFO() not working...
  493. Need good idea
  494. DB2 UDB v8.2 Fixpack 9 Problem starting Information Center
  495. tablespace move from 32K to 4K page size on same instance
  496. DB2 version info
  497. Error Installing ESE Fixpack 9 for Windows - Help Please
  498. error sqlriResolveOpFunc
  499. Quck question on port numbers for V8.X and HP
  500. Stored Procedures: RESULT SET.
  501. Stored procedures debugging.
  502. DB2 Fixpak 9 now available for LUW
  503. [Fwd: Double lock on iseries db2 ado.net transaction]
  504. Sr. Database Engineer Needed - Preferably DB2 (Silicon Valley)
  505. Help creating trigger
  506. db2 connect statement with current schema
  507. DB21015E - New Error with Fixpack 8?
  508. how to copy a clob column data......
  509. selecting data based on rowid
  510. federated database
  511. Simple question
  512. how to pass value to a stored procedure at runtime....
  513. SQL
  514. Clone a partial DB on Linux running in circular mode
  515. SET INTEGRITY question
  516. Help with an SQL Query
  517. Calling sqleintr or exit causes program (linux) to hang (due to deadlock by pthread)
  518. Cannot grant sysproc function to user
  519. DB2 Data directly into Microsoft Excel
  520. DB2 crash?!?
  521. UDB v 8.1 - SQL0925N SQL COMMIT invalid for application execution
  522. UDB v 8.1 on win2000 - SQL0925N SQL COMMIT invalid for application execution
  523. Connect to remote server using db2 and Perl
  524. Translate this Oracle Trigger ...
  525. Help with Oracle to DB2 trigger translation
  526. Row Locking issue
  527. event monitor -dropped default one
  528. Db2 server problem, Urgent please need suggestions
  529. Data Compression
  530. SEARCH / KNOWN discovery question
  531. Same statement, different application, different runtime
  532. If statement
  533. Passing a resultset from a nested Stored Procedure
  534. Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L
  535. problem running db2cc, DB2 v.8.2 on AIX
  536. Generating rows on the fly
  537. Please Help - DB2 Specialist Consultant Required
  538. sql1042C / sql1036C on create database?
  539. client v7 to connect v8.1 mts error
  540. DB2 Optimizer is not using Summary Table (DB2 V 8.1.7)
  541. Load commit
  542. INSERT INTO ... FROM NEW TABLE
  543. Problem when archiving log files
  544. DB2Advisor error
  545. How to configure windows with ibm db2 odbc driver?
  546. Proyectos de Inversion en IT en la Universidad Tecnologica Nacional
  547. DB2 SNMP Monitoring - Missing the Boat - Big Time
  548. JDBC Driver Defaults
  549. Client Access ODBC DB2 driver problem
  550. LDAP authentication for DB2